transfer spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am trying to import an excel spreadsheet where i want the 2nd sheet in the
excel file. it is named price. i tried to put the name price in the range
section but access is telling me the DB could not find the object "price". I
have spelt the name and file location correctly so i am a little lost. Can
anyone help out here?
Thanks
George
 
General syntax for the Range argument when specifiying a worksheet name:
"WorksheetName!"

So for you:
"Price!"

If the worksheet name has spaces in it, then delimit with ' characters:
"'Worksheet Name'!"
 
Back
Top