Hi,
can anyone help with this...

I wan't to automate the import of approximately 30 text files (monthly) into an access database - ideally to append into a master table. They all contain exactly the same fields. Is there any way this process can be carried out automatically, maybe using a macro command button or for it to start automatically upon opening the database?

Any help/ guidance or pointed in the direction of where else I can look would be greatly appreciated.

Hi

One way would be to link all the files into your db, then write queries to append to a table, or if you want to be a bit slicker
then you can code it using the following vba command.

DoCmd.TransferText [transfertype][, specificationname], tablename, filename[, hasfieldnames][, HTMLtablename][, codepage]

Have a look at the help in access for TransferText

If you're still stuck post back and I'll tell you how to do it.

Steve

Hi, I am doing a app that searches, imports, then appends it to an Access database.  Can anyone help my with this?  I have found alot of ways to do this in vb 6 but .net has changes so many codes that I am alittle stuck.<br />
<br />
Any help would be greatly appreciated!!!!<br />
Please respond A.S.A.P <img src="emoticons/smiley.gif" border=0>