import excel file error 3078 dbo_

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

msnews.microsoft.com

Hello,

I'm trying to import an excel file in an existing table with the following
command:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8,
"dbo.tmpImport", FileName, True, "Data"

and got the error 3078 and explanation: "Access could not find the table
'dbo_tmpImport' ..."

Note the underscore instead of the point.

Configuration: MS Access 2003 (Office2003SP1 installed), ADP Project,
SQL2000SP3
Login as different database user other than dbo.

If I try it with Acc2002, it works. Seems to be a bug in Acc2003. Can anyone
confirm it or tell me, how to avoid or workaround?
 
Hallo Mathias

I've the same problem. When i will import a file, Access 2003 say: "Could
not find the table "dbo_Import", but i've written "dbo.Import".
And the same db works with Access XP without any problems!
May you or somebody else found now a solution?

Regards
Lars

(Win XP SP1, Office 2003 SP1, MS Jet 8.0 SP8)
 
Back
Top