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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Backup software / routines 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
parse a text file 1
Restrict memo field to size of text box 2
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Text box input??? 1
Autonumber key with text files 2
Import files into access 1

Back
Top