DoCmd.TransferSpreadsheet acImport in Access Project

G

Guest

I'm trying to import an Excel spreadsheet into an Access project. If I put in
the table name which is owned by dbo it doesn't find the table and crerates a
new one owned by me (I have dbo permissions). If I put the dbo name in front
of table like this, dbo.tablename it comes back with an error saying it can't
find dbo_tablename. No matter how I put the table name in; (dbo.tablename),
[dbo.tablename], tablename (dbo), it either changes the dot to an underscore
or says it can't find table. Is there anyway for this to find the table
that's already in the database?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import text file - user is not dbo 7
C# Regular Expression 5
Change linked table destination--Access Link to SQL 2005 1
Identity_Insert won't turn off 3
import excel file error 3078 dbo_ 1
Access 2003 ADP to SQL 2000 9
Error in docmd.transferspreadsheet? 11
Problem with DoCmd.TransferSpreadsheet acImport 4

Top