automate import text file

[tantejo]

hello all,
i did a search on the answer base, but didn't find any thing i was looking
for , so
i want to ask a question about importing data into acces from a text file om
a regular (weekly) basis. from an oracle database at my work i can export
some data to a word document. after i convert this document to plain text i
can import this into access. this works fine, but i wonder if i can automate
this import proces ??? i have only 1 table with 35 fields, and i like the new
data to be appended in the table. is this possible ??
if someone could give me some hints / advice where to look and how to start
this thing, i would be very happy !
greetings and many, many thanks, johan

 

[Nikos Yannacopoulos]

Johan,

Since the file maintains a fixed format every time, one way to do it is to:

1. Go through the menu: File > Get External Data > Link Tables and
follow the wizard to link the text file;
2. Make an append query that appends records from the linked table (aka
the text file) to the target table).

Once this is done, all you need to do every week is to save the new text
file over the previous one (same folder, save file name) and run the
append query.

HTH,
Nikos