Import & append multiple text files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have multiple text files, each of which contains multiple complex records -
one file a day which contains all telephone calls made on that day.
The records are fixed width. I imported the first file and carefully set
each field (name, type, length, etc) and it worked fine. However, when I try
to import the next day's file as an append (or combine multiple days into a
month and try to create a new file), Access does not reuse the import
criteria. It wants me to set all the parameters again. This is a royal pain.
Yes, the txt files I am importing are all the same format.

How do I force Access to use the same import parameters??
Thanks
 
You need to create an Import Specification. Do the import by hand (File, Get
External Data, Import) and when you have the wizard up, click on the Advanced
command button. You can set all the specs there, then click Save As button.
Give it a name. In your TransferText method, you can identifiy the spec to
use.
 
Back
Top