Import from text file

B

Bill Linares

I'm new to this, so this might be trivial

I need to import data stored in text files into Access tables. The whole
thing is pretty straight forward done manualy; unfortunately it has to be
done hundreds of time. I need help on VBA for the following:

1. how to find out the number of files in a directory.
2. how to import text data into an access table using VB

Thanks
 

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

Import mutiple name text files into Access 2003 1
Help, how do I import a CSV file when Negatives are in Parenthesis 3
Data type issue when importing from excel to access 1
Import text file to access database via Excel VBA. 1
Text Import Specification Missing 3
PLEASE HELP: automate process to import tables from notepad to acc 9
Parsing Text file and import into Access Table. 12
Import same Excel ranges from many workbooks 3

Top