getting error using docmd.transferdatabase

[haggisns]

Hi,

I am trying to import a table on SQL Server 2000 into a a new table on my current access database.

DoCmd.TransferDatabase acImport, "ODBC Database", _
"ODBC;DSN=devserver2000;LANGUAGE=us_english;" _
& "DATABASE=CompPC", acTable, "PCS", "PCList"

When I run this statement I get the following error:

Run time error "3011"

The microsoft jet database engine could not find the object PCList
make sure the object exists and that you spell its name and the path name correctly.

I thought the point of this method was to create the new table so of course it would not already exist.



For testing: I created a empty PCList table on the access database and ran it again and this time it will say " object PCList1" so it actually does find PCList object but parses on a 1 to give PCList1 because PCList already exists. But then it can't can PCList1 that it just created as a placeholder.

I am using SQL Profiler and the method is creating a connection to the server successfully.

Can you please help how to get the syntax correct or may be it is an environment issue.

thank you

[NTC]

What occurs if you attempt to link to the table, rather than import?