AaronKempf.com | CareerDBA.com | FullStackWP.com
unread,Jan 11, 2021, 5:36:53 AM1/11/21You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
I use SQL Server SSIS or DTS to import multiple worksheets no problems.
I've even done all of this with Access Data Projects.
Docmd.TransferSPreadsheet isn't that the name of it?
and the last argument
Path!Sheetname.
I mean, if you can't import Path!Sheet1 into a table called Sheet1 and Path!Sheet2 into a table called Sheet2, you've got bigger problems than this.