Automate import of text-files

[sverre]

Hi

I have two text-files that I regularly import in a mdb. I have written
import specifications for both files. One of the files appends data on an
existing table and the other file replaces data in an existing table.

Can I write a macro to make Access do the following:

1. Import file 1 with my importspecification called "extrakt" wich appends
data to the table accounting.

2. Import file 2 with my importspecification called "sesam" wich
replaces/overwrites data in the table "sesam".

The names of the textfile are different every month, but it would be easy
for me to have same name every time I import the files. It would also be easy
for me to put the files in same library every time I do the import.

Best regards
Sverre

 

[Wayne-I-M]

HI

Have a look at this - I posted it a whilst back. It is for importing
external data in another access DB but it would be simple to alter it to
bring in any form of data

http://groups.google.com/group/micr...roup:microsoft.public.access#8736182d9b1c59de

If you have problems post back with specific questions

Just one point I would not overwrite the information you have in your table
"sesam" before you run another append query to add the data to an achive
table - then run a delete query to remove the data after which you could run
the append. Do this "just in case". If you find after a while that you
don't really need the data you can delete it but it's alwasy a good idea to
keep it for while "just in case"



Good luck