open excel

[jnewl]

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

 

[OldPro]

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

Are you using Access's TransferSpreadsheet( ) or TransferText( ) for
the import? Have you tried using an import specification?

 

[jnewl]

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

 

[OldPro]

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 -

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