J Jonathan Apr 6, 2009 #1 Can I import a single Excel Spreadsheet(worksheet) into multiple Access tables in a single database? And how?
Can I import a single Excel Spreadsheet(worksheet) into multiple Access tables in a single database? And how?
F fredg Apr 6, 2009 #2 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.
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 Apr 6, 2009 #3 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 <--
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 Apr 6, 2009 #4 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.
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.
P Peter Hibbs Apr 6, 2009 #5 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.
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.
