Importing texsts files

  • Thread starter Thread starter Grodon
  • Start date Start date
G

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