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.
 
Top