Access Import/export help please

Smartman

Junior member
12 0
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
 

RedE

Junior member
25 2
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