Import an Excell spreadsheet

[ggreg]

Can I put code in a Module that would at a certain time every day check for an excel file and if there is an excell file then it would import it into an access table?

 

[hneal98]

Yes. You would need to read up on the Timer control.

 

[lewds]

Hi..

If Access is running, a code module could moniter the date and time and the existance of an Excel file to import.

If Access is not running, a batch file or VB script could be placed in the Task Scheduler to run and check for an Excel file and then call Access for the import.

 

[ggreg]

Lewds,

Having a batch file (which would import an Excel spreadsheet into an Access table) sitting in the Task Scheduler was exactly what we were thinking about. It would kick off every morning around 3am and import the data into Access. The trouble is we don't know how to write the code for the batch file. We were just going to put some code into NotePad and save it as a .bat file and place that .bat file in the scheduler. We've done this before with other projects, but never imported before. Can you help with the code or point us to where someone may have the code that could perform this? Thanks, Greg

 

[ggreg]

lewds,

Got an answer to my question thanks for helping no more reply needed