Importing texsts files

[Grodon]

Is there a way to set up an 'import specification' so that
a text file will be imported the same way everytime (data
types, columns, etc.) without having to go through the
steps of the wizard? Access has this feature, just trying
to do the same thing with Excel.

Thanks in adv.
Grodon
..

 

[Tim Williams]

just record a macro when opening the file.

If the filename will change, then you can modify the macro using
GetOpenFilename to allow you to select a specific file.

tim