Importing excel spreadsheet into multiple Access Tables.

J

Jonathan

Can I import a single Excel Spreadsheet(worksheet) into multiple Access
tables in a single database? And how?
 
F

fredg

Can I import a single Excel Spreadsheet(worksheet) into multiple Access
tables in a single database? And how?
Click to expand...

Look up the TransferSpreadsheet method in VBA help.
 
S

Stefan Hoffmann

hi Jonathan,
Can I import a single Excel Spreadsheet(worksheet) into multiple Access
tables in a single database? And how?
Click to expand...
Yes, you can. Use the DoCmd.TransferSpreadsheet method. Depending on the
data structure in Excel you need

a) multiple calls to it, if the data is distributed over several sheets
or
b) one call to it, if the data is in one tabular sheet.

In both cases you should import the data into a import table using
import specifications:

http://office.microsoft.com/en-us/access/HA012194191033.aspx

Use queries to validate and/or sanitize the data. Then use append
queries to add the data to its final destinations.


mfG
--> stefan <--
 
K

KARL DEWEY

Yes, first either import or link into a single table then use append or make
table query to put whatever data you want into whatever table you want.
 

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
Access Subscript out of range when importing into access 2010 from excel 0
How can I import an unstandard Excel worksheet into Access 2007? 3
Access Problem using dates in a query in access 0
How can I push Access Data into Excel from Access 2007? 2
Import multiple Excel tabs into access 4
Counting multiple memberships 1
Import to many to many table 7

Top