Access Import/export help please


Junior member
I use access database and I want access to automatically import data from a text file when info is entered into that file .
Any idea's where I can get the routine to do this
I running windows XP

Thank you


Junior member
You have 2 options (at least):

(1) In the database windows,click NEW and create a Linked table which you point at the text file.
The text file will then appear to act like a native Access table

(2) Import the data into an existing table. Goto File-Get External Data-Import

Option 1 is great if you have a well behaved and formatted file. Also has the benefit of allowing you to substitute a new text file and get a new table

Option 2 is best for retaining the data. HOwever, you will need to ensure uniqueness, so you are probably better off using an intermediate query to load you main table
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock    No Thanks