View Full Version : Importing data into Access Via the Wizard


wardy
02-16-2008, 11:25 PM
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

boblarson
02-16-2008, 11:41 PM
Yes, it is possible. Look into the DoCmd.TransferSpreadsheet method. It is in the VBA helpfile.