How do you use the range option in transferspreadsheet?

  • Thread starter Thread starter Corey
  • Start date Start date
C

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.
 
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.
 
Back
Top