TransferText Importing Txt file

H

Houston

I'm trying to using the DoCmd.TransfrerText VBA on an access2003 ADP with a
SQL 2000 backend.

I'm trying to import into an existing table named "ABC", but I get and error
message saying "Microsoft Jet cannot find table dbo.ABC" so it creates it.

When I'm logged on as say any other user, and look at the database window I
see this as the table name "ABC(dbo)"

Any help out there???
 

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

Top