import Excel into Access by batch

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need to imort Excel into Access by setting in task manager a time to run a
batch
on a daily bases. Not sure about how to write the batch code to import an
Excel file
into an Access table can someone help with the syntax?
 
Why not create an AutoExec macro (that's the name of the macro) in ACCESS
that will do the import for you; then when the ACCESS database is opened by
the task manager, the macro will run automatically. Just be sure to put a
Quit command as the last step in the macro.
 
ken, thanks for the reply not exactly sure I under stand AutoExec Macro,
but I am going to post what I did because I got it working
I did make a macro for doing the import and closing down Access after the
import
but I did create a batch or(.bat)file like below:

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
"Y:\nameoffolder\nameofdb13.mdb"/xquit

just make sure no space in between the two lines above....
the first line is the location of your MSACCESS.EXE where its located on
your computer
the second line is the location and name of your db with a /x and no space
and name of macro

quit is the name of the macro but you need the x to tell it to look for
macro with the name of what ever you name your macro is,
and final you go into your task manager to set the time and how offend you
want
the bat file to run in our case its going to be daily.
thanks again Ken!
 
Back
Top