Groups
Sign in
Groups
microsoft.public.access
Conversations
About
Send feedback
Help
info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Learn more
Import an Excel workbiook with 22 associated spreadsheets help
6 views
Skip to first unread message
Martin 忽帕
unread,
Feb 16, 2017, 11:51:18 AM
2/16/17
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Hello,
Access is all new to me.
I tried to import an excel workbook with 22 spreadsheets, but only the
first spreadsheet seems to have come through or is available
Are the rest there?
Any help appreciated
--
Martin
忽帕
AaronKempf.com | CareerDBA.com | FullStackWP.com
unread,
Jan 11, 2021, 5:36:53 AM
1/11/21
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
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.
0 new messages