transfer spreadsheet

G

George

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
 
K

Ken Snell \(MVP\)

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'!"
 
Top