G Guest Apr 2, 2004 #1 Does anyone know how to important multiple excel data worksheets into one access database, in order to merge several into one?
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 Apr 2, 2004 #2 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
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
