Need the exact path and format for Tranferspeadsheet macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I am trying to import a spreadsheet to a table in Access but am having
problems.
The file is on the D disk
the folder is called "Tutorial"
The workbook is called "finish"
and the sheet I need is called "up"
The range is A2:F44
Can some one give me the exact pathway because I get the error "Can't find
path or File"

Please Help

Regards

Chris
 
How are you trying to use this information? Tell us the specific arguments
and the values that you are trying to use for a TransferSpreadsheet action.

In a TransferSpreadsheet macro, the range (worksheet and cells) goes into a
different argument than the path to the file.
 
Hello,
I am using IMPORT as TransferType
I am using Microsoft 8-9 as Spreadsheet Type( I have Office 2000)
The Access Table I am trying to Import To is named Finish
The File is in a Folder called Tutorial on a D Drive and the workbook is
called Finish.xls. The sheet I need to Import from the Finish workbook is
named Up
The range is A2:F44
Therefore fore For the File Name I entered the path D:\Tutorial\Finish!up
The Range is A2:F44
Thanks

tHANKS
 
Filename expression should be
D:\Tutorial\Finish.xls

Range expression should be
Up!A2:F44


--

Ken Snell
<MS ACCESS MVP>
 
Back
Top