How do you use the range option in transferspreadsheet?

[Corey]

I have a spreadsheet to import into Access. It comes from
the 2nd worksheet in the workbook. How do I tell Access to
go the second worksheet?

As this database is a multi-user database, are the
advantages to using importing the cells into recordset. If
yes, a guidelines or tipe on how to proceed?

Thanks.

 

[John Nurick]

Hi Corey,

To specify Sheet1, pass
Sheet1!
as the range argument. IIRC if there's a space in the sheet name, you
need to enclose it in apostrophes
'Sheet One!'
or perhaps
'Sheet One'!
Either way it's the same syntax that Excel itself uses.

 

[Ken Snell]

IIRC if there's a space in the sheet name, you
need to enclose it in apostrophes
'Sheet One!'
or perhaps
'Sheet One'!

It's the latter one!