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
..

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

"Grodon" wrote in message
...
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
.