By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,078 Members | 2,159 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,078 IT Pros & Developers. It's quick & easy.

basic question - cannot get the range name correct when importing Excel worksheet

P: n/a
JC
Hey there,

I am trying to import an excel spreadsheet using the code below. Every
time it gives me a "cannot locate object" error.

Does anyone know what I am doing wrong?

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTest",
"H:\everyone\Shared\ASC Processes\State Aid Processing
Databases\Lexington Hurns.xls", 0, "Lexington Hurns!Total Cvue Data"
Thank you in advance,

JC

Oct 6 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Try this

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"tblTest",
"H:\everyone\Shared\ASC Processes\State Aid Processing
Databases\Lexington Hurns.xls", 0, "Total Cvue Data!"
HTH

JC wrote:
Hey there,

I am trying to import an excel spreadsheet using the code below. Every
time it gives me a "cannot locate object" error.

Does anyone know what I am doing wrong?
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"tblTest",
"H:\everyone\Shared\ASC Processes\State Aid Processing
Databases\Lexington Hurns.xls", 0, "Lexington Hurns!Total Cvue Data"
>

Thank you in advance,

JC
Oct 6 '06 #2

P: n/a
JC
Thanks CyberWolf

That did the trick. I knew I was missing something small.

Justin

Cyberwolf wrote:
Try this

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"tblTest",
"H:\everyone\Shared\ASC Processes\State Aid Processing
Databases\Lexington Hurns.xls", 0, "Total Cvue Data!"
HTH

JC wrote:
Hey there,

I am trying to import an excel spreadsheet using the code below. Every
time it gives me a "cannot locate object" error.

Does anyone know what I am doing wrong?
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"tblTest",
"H:\everyone\Shared\ASC Processes\State Aid Processing
Databases\Lexington Hurns.xls", 0, "Lexington Hurns!Total Cvue Data"


Thank you in advance,

JC
Oct 6 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.