Auto Import

[GlenLynam]

Morning,

Is it possible to auto import a csv file every day at a set time?? If so please can you explain how. The file location will be the same each day as will the filename.

Thanks

Glen

 

[smedvid]

One approach is to create an MS Access DB with an AutoExec Macro that call a Function() for the import upon start up and then exits. Once you have the necessary code for the Import Process, you can create a Scheduled Task on a designated PC that simply opens the MS Access file. Once openned, it will fire the import function and then close. You may even consider sending an email to confirm that the import was finished or log the import activity to a table for reference and troubleshooting. htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[GlenLynam]

Cheers steve have gone a similar route am writing a exe .n vb that i can put in scheduled tasks to exactly that, god idea about he mail will add that in. Thanks, Gen