Automate import of text-files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sverre - 13 May 2008 11:41 GMT

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

Reply to this Message

Wayne-I-M - 14 May 2008 13:49 GMT

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/microsoft.public.access/browse_thread/thread/ca58
39ab4cca4358/8736182d9b1c59de?lnk=st&q=wayne+external+group%3Amicrosoft.public.a
ccess#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

Signature

Wayne
Manchester, England.

> Hi
>
[quoted text clipped - 16 lines]
> Best regards
> Sverre

Reply to this Message