Access 2007 VBA Import Excel

I have 20 Excel 2007 files that I would like to import into 20 seperate tables in an Access 2007 DB. What is the VBA code for importing.

1 of the 20 Excel files has two sheets that I need imported into two seperate tables.
Who is Participating?
PatHartmanConnect With a Mentor Commented:
DoCmd.TransferSpreadsheet ....
Use intellisense to get the syntax or read about it in help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.