Automated Importing of Tab Delimited Text Files

[Guest]

Working on a quick Access 2003 project, and honestly, I haven't touched the
stuff for a while, so I'm a little rusty. I am trying to import tab
delimited .txt files into tables in the DB using a macro (TransferText
Method).

I can get it to work perfectly if a change the files to comma delimited, but
the tabs are giving me a problem. Can anyone out there lend a helping hand???

 

[Guest]

Do the transfer by hand the first time. Once the transfer dialog is open,
set up the delimiters, etc as you need them. The click on Advanced. You can
specify field names, data types, etc. The Save as an Import Specification.
Now, in your TransferText, you will have to add the import specification
file name to that command. Since I don't use Macros, I don't know if they
support that, but they should.

 

[John Nurick]

Hi Donald,

You need to use import specifications or schema.ini files to tell the
system that these are tab-delimited files.

To create a specification, click the Advanced button in the text imprt
wizard while importing the file manually.