Specifying which tab using TransferSpreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raj - 23 Sep 2004 15:19 GMT

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

Reply to this Message

Ken Snell [MVP] - 23 Sep 2004 17:01 GMT

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

Range: SheetName!A1:K41

If there are spaces:

Range: 'SheetName'!A1:K41

Signature

Ken Snell
<MS ACCESS MVP>

> I am using TansferSpreadsheet to import into my
> database. I have 5 tabs in the spreadsheet and I am not
[quoted text clipped - 6 lines]
> Has Field Names: Yes
> Range: A1:K41

Reply to this Message

Raj - 23 Sep 2004 18:10 GMT

Ken,
Thanks!!

>-----Original Message-----
>If there are no spaces in the SheetName (replace with actual name):
[quoted text clipped - 17 lines]
>
>.

Reply to this Message