Importing more than one Excel data base into one Access database

G

Guest

Does anyone know how to important multiple excel data worksheets into one access database, in order to merge several into one?
 
M

M.L. Sco Scofield

Take a look at the TransferSpreadsheet action, for macros, or the TransferSpreadsheet method of the DoCmd object for VBA.

For multiple sheets, just use multiple lines specifying a different range for each sheet.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Creating new Access 2007 database and importing the old data 1
How can I push Access Data into Excel from Access 2007? 2
Import from Excel 2003 to Access 2003 4
Importing excel spreadsheet into multiple Access Tables. 4
Import data from Access to Excel containing VB code 3
import multiple Excel worksheet into a main Access table 1
Importing from Excel - error when adding to existing table 6

Top