open excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

need to import an excel file to access. but before importing, need to change
a field to text.
numberformat = "@" does not work, as still get conversion errors.

when i do a text to column, it will work properly, as i did this manually
with get external data.

what is the syntax for text to column for a specific column. the code would
be within a with statement

thanks
 
need to import an excel file to access. but before importing, need to change
a field to text.
numberformat = "@" does not work, as still get conversion errors.

when i do a text to column, it will work properly, as i did this manually
with get external data.

what is the syntax for text to column for a specific column. the code would
be within a with statement

thanks
Click to expand...

Are you using Access's TransferSpreadsheet( ) or TransferText( ) for
the import? Have you tried using an import specification?
 
using transferspreadsheet. no on import spec. would not the text to column
concept work inside a with? that is what i get when i record an excel macro.
just do not know the syntax for access vb
 
using transferspreadsheet. no on import spec. would not the text to column
concept work inside a with? that is what i get when i record an excel macro.
just do not know the syntax for access vb






- Show quoted text -
Click to expand...

I don't think Access works like that. Try the import specification.
 
Back
Top