Importing .txt files into Access

[Pari]

Hello all,


I have been searching the web for help in importing data into Access. At present I have approximately 30 tables that I create each month. Some of these tables are replaced and some are apended.

To help stream line this process can anyone please help me to create a macro, VBA script that can do the above. Please note I am no developer so am really looking for some help here!

Regards. Pari.

 

[Steve R.]

In Access help, look-up DoCmd Object Members. Scroll down to TransferText.

 

[Pari]

Thanks for the advise Steve,

I am actually not a programmer so if at all possible would really apprecaite some more detailed help, such as help with the actual coding if possilble?

Thanks and kind regards. Pari.

 

[DCrake]

The instructions you were given could not be more simpler. You need to create a new macro and select TransferText. the macro will then ask you several questions. Complete the questions, save the macro and run the macro.

If you have unusual files that Access is having problems with then this may need to be done in code. It may also help if you could post a sample of the data you want to import.

David

 

[Pari]

Steve, Dave,

Very sorry here but I could not honeslty find that string in the help file ( I have Access 2000). I am trying to import .csv files.

Regards. Pari.

 

[DCrake]

Hey! first you want to import .txt files (as per heading) now you are saying .csv files? which ones do you want?

Try using the main menu to find the Add New macro option. It should come under Tools

David

 

[Atomic Shrimp]

I am trying to import .csv files.

In practical terms, there's usually little difference - that is, data presented in a .txt file to be imported into a database is often comma-separated inside the file. (not always - it may be fixed width or something else, but CSV is common)

- And conversely, a .csv file is just a text file with a different extension. The .csv extension tells applications to expect that the content *will* be comma-separated, but apart from that, it's just text.

So the methods for importing .txt and .csv files are pretty much identical.

 

[Steve R.]

I am actually not a programmer so if at all possible would really apprecaite some more detailed help, such as help with the actual coding if possilble?

If you intend to use Access, you will need to become a "programmer". You may want to start out with the following book:
Access Database Design & Programming, Third Edition