Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing Multiple Workbooks from Excel to Access 1

Status
Not open for further replies.
monrosal

monrosal

Programmer
Aug 22, 2000
42
US

Does anyone know how I can specify which workbook to import when I use the TransferSpreadsheet? In the code, there is no argument to specify a workbook. Is there another method I can use? Thanks

Ramon
 
Sort by date Sort by votes
Did you find out how to do this? I am attempting to import about 150 Excel workbooks (each with 10 spreasheets) into Access. It is killing me?!
 
Upvote 0 Downvote

Use the Range parameter to name the spreadsheet.

Example:

DoCmd.TransferSpreadsheet acImport, _
acSpreadsheetTypeExcel9, "TableName", _
"c:\data\excel\workbookname.xls", _
False, "spreadsheetname!"

NOTE: The ! is required. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
706
OCM
OCM
renigar
  • Question
Access VBA Syntax Error
Replies
5
Views
228
Andrzejek
Andrzejek
renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
384
renigar
renigar
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
607
lmcate
lmcate
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
676
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top