VB code to import Excel sheet

B

BobC

I'm looking for the VB code to copy an Excel Sheet to an Access 2007
table. The sheet in is a know location.
I also want to clear the Access table prior to importing the Excel Sheet.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing any excel files with any sheet name into different tables in MSAccess using code 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Alt codes 4
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Excel, assign cells in multiple worksheets from one sheet 1
import email address from excel.. 2
excel or access database? 2
Excel Macro to un-mute Audio/speakers. 15

Top