Importing Excel into Access, subduing Column Header Errors

[oliver_penney]

hi

in VBA, i'm importing a .xls into access, but the column headers have leading spaces and it doesn't pull them in

any suggestions?

thanx in advance

ol

 

[oliver_penney]

Re: Importing Excel into Access, subduing Column Header Erro

got the field, just ned to populate it with the same thing now....

 

[DonkeyOte]

Re: Importing Excel into Access, subduing Column Header Erro

to overcome spacing

[field name]

instead of

field name