I'm trying to set up a macro to import multiple text files into Access 2000. Can you please tell me how to do this. Obviously I can set it up to import a specific file from a directory, but what i would like it to do is to import all files with the extension *txt for example. Is this possible. Thanks

It really repends on what your trying to accomplish. If you are talking about importing a singel text file into a single field or is you want to import a CSV file into a new table or what. You have to provide a bit more detail on your problem for people to give you much help on how to go about it. The more I learn about computers the more I hate them. Kinda like people.

Sorry, I was'nt very clear. I have set up a macro with an import specification for a text file which has records for 4 fields, into a table. For example the file which has: Product Date Quantity Cost xxx xxx xxxx xxx xxx xxx xxxx xxx There are no headers in the text file but the import specification inports into these colums within the table in Access. Each text file has hundreds of records to be imported this way, but each text file follows exactly the same format. This is why i want to find a way to import multiple files automatically, following this exact same format, as i have 50-100 text files to import. Writing a macro in the macro wizard to look for a single specific file obviously works fine, but each of my 50-100 text files has a different name. Thats why I was looking for a way to import all files of a type.