Is it possible to export excel data to access when opening the file!?

fixemup27

Registered User.
Local time
Today, 09:52
Joined
Feb 23, 2012
Messages
11
Is it possible to export data to an access database upon opening an excel file. (what I mean: Instead of getting into the file and going through the prompts to export it, can I write some code via vba to have it export to the same access database everytime once the file is clicked to open?) At my business we have the same reoccuring report and Im looking for less clicks as possible. If my users can simply click on the particular file they want, the code will do the work for them in exporting the information. Leaves a lot less room for error. THANKS!!
 
Do you want to open excel then fire the data into Access
Or do you want to just click a button on Access and pull the data in automatically?
 

Users who are viewing this thread

Back
Top Bottom