Importing excel spreadsheet into multiple Access Tables.

[Jonathan]

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

 

[fredg]

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

Look up the TransferSpreadsheet method in VBA help.

 

[Stefan Hoffmann]

hi Jonathan,

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

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

 

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

 

[Peter Hibbs]

Jonathan,

If this is a one-off operation then you could try the Excel to Access
Converter Utility at :-
http://www.rogersaccesslibrary.com/...?TID=183&SID=e81a164e2314187z3e8587231e28cb7d

Peter Hibbs.