Need the exact path and format for Tranferspeadsheet macro

[Diggsy]

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

 

[Ken Snell [MVP]]

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.

 

[Diggsy]

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

 

[Ken Snell [MVP]]

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

Range expression should be
Up!A2:F44


--

Ken Snell
<MS ACCESS MVP>