Importing data into Access Via the Wizard

wardy

Registered User.
Local time
Today, 13:58
Joined
Sep 4, 2007
Messages
21


Good morning all,
i have a feeling this could be a simple yes or no answer,, at the moment i am using the 'Import Data Wizard' to pick-up an excel file that is up-dated on a daily basis, this file always sits in the same directory and always has the same file name, ideally i would like to have an action button that draws the data in without having to use the wizard each time,, does anyone know if this is achieveable? if so, anyhelp would be much appreciated.
as always, many thanks
 
Yes, it is possible. Look into the DoCmd.TransferSpreadsheet method. It is in the VBA helpfile.
 

Users who are viewing this thread

Back
Top Bottom