Discussion Locked

Importing text files to Access 97.

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We set up an import specification for seveal text files we want to import. We created a macro to automate the process and import several files one after the other. The macro worked. We then converted the macro to VB code. The code works, but only if we do a manual import of one of the text files first. We need the import to work in code without having to prime the pump. Any ideas will be appreciated. Thanks in Advance.

4 replies

by roc180

When you say the code works but only if you manually import the file first, are you saying that when you execute the code for the first time you get a run time error? My guess is that your not correctly identifing your spec when you execute the code and after you manually identify the spec then it uses it for the rest of the process. Send me your DB(make sure to include the spec) and a test file, and I'll take a look at it.

Neal Martinelli

This discussion is closed to new replies.