Direct Importing Excel data into ACCESS database

[jen1701]

Dear All,

I would like to have the function to directly importing Excel data into the Access application when the application is opened. The Excel data file is updated all the time. I want the table in the Access application also being updated when the Excel data is updated. I am not sure where to start with. If someone can give me some ideas, it would be very helpful. Thanks.

Jen

 

[PHV]

Take a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jen1701]

Hi PHS,

Thanks for the quick reply. I am reading the DoCmd.TransferSpreadsheet method and just wonder where should I put all these code. I guess I need to create a module, so when the Access is opened, the code can be excecuted and the data can be automatically imported into Access table. Is it right ? Thanks.

Jen

 

[PHV]

You may create a macro called AutoExec that'll be automatically executed when the database is opened.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jen1701]

Thanks again PHV.
I do have an AutoExec macro. It detects the idle time and open the main menu. I guess I can add OpenModule to run the importing excel data code in this macro. Right??
Thanks,

Jen