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 Excel into Access97 problem

Status
Not open for further replies.
punky

punky

Programmer
Mar 21, 2001
29
US
Trying to bring in Exel Spreadsheet, but statement tries to find file in D Drive when I am in O Drive. Statement reads as follows: DoCmd.TransferSpreadsheet acImport, 0, TableImported, TableImported & ".xls", True, ""
 
Sort by date Sort by votes
And what about this ?
DoCmd.TransferSpreadsheet acImport, 0, TableImported, "O:\" & TableImported & ".xls", True, ""

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Concatenation problem 3
Replies
5
Views
633
Moss100
Moss100
Moss100
  • Locked
  • Question
Filter vba problem
Replies
1
Views
282
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
184
Viswa.R
Viswa.R
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
262
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
433
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top