How can I load a text file into an access database??

[vivis]

Hi, I have a script that checks disks on servers and save this data in a table in an access database. I need to copy this table every time the script runs in a text file, and I need to load this text file in another table every week but I dont know how to do this, Can anyone help me please!!

 

[arst06d]

automate or shell to Access in your script and run a macro to do the import

If you have sql server, you could schedule a DTS package to check for the existence of the file and do the data load.