Specifying which tab using TransferSpreadsheet

[Raj]

I am using TansferSpreadsheet to import into my
database. I have 5 tabs in the spreadsheet and I am not
sure where in the Marco to put which tab I am importing.
This is my Marco:
Transfer Type: Import
Spreadsheet Type: Microsoft Excel 8-10
Table Name: 8transfer
File Name: I:\Revenue\PROJECTS\8xx\WORKING022404
Has Field Names: Yes
Range: A1:K41

 

[Ken Snell [MVP]]

If there are no spaces in the SheetName (replace with actual name):

Range: SheetName!A1:K41


If there are spaces:

Range: 'SheetName'!A1:K41

 

[Raj]

Ken,
Thanks!!

-----Original Message-----
If there are no spaces in the SheetName (replace with actual name):

Range: SheetName!A1:K41


If there are spaces:

Range: 'SheetName'!A1:K41


--

Ken Snell
<MS ACCESS MVP>




.