Text files

  • Thread starter Thread starter Graham Bennet
  • Start date Start date
G

Graham Bennet

Hello All,

What is the best way to input data into a table from text files.

Graham
 
-----Original Message-----
Hello All,

What is the best way to input data into a table from text files.

Graham
Click to expand...
Hi Graham, your post is a little vague. I assume you want
to automate importing text files?

If 'yes', then I suggest that you use manually import the
text file. When completing the steps of the import wizard
save an import specification with a descriptive name. Use
either a macro or vba to import the text file using this
saved import specification. Lookup online help for
TransferText for more information.

Luck
Jonathan
 
Thanks Jonathan


Jonathan Parminter said:
Hi Graham, your post is a little vague. I assume you want
to automate importing text files?

If 'yes', then I suggest that you use manually import the
text file. When completing the steps of the import wizard
save an import specification with a descriptive name. Use
either a macro or vba to import the text file using this
saved import specification. Lookup online help for
TransferText for more information.

Luck
Jonathan
Click to expand...
 
Back
Top