transferdatabase

[tmort]

I'm trying to use the tansferdatabase command and am getting an error.

First I was having trouble with the line of code and found that if I left the parenthesis off the compiler would accpet it.

I'm trying to import a table from one access database (version unknown) to an Access 2000 db.

Whan I run it I get a message saying that:
the type insnt an installed db type or doesn'ty support the operation you chose.

If I use "access" as the optional database type argument I geht the same message only it says the Access database type isn't an installed database type...

The line of code I don't that is doing this I thin is:

DoCmd.TransferDatabase acImport, , "db path", acTable, "temp county", "county"

Any ideas

Thanks in advance

 

[Tim K.]

Try this.


DoCmd.TransferDatabase acImport, "Microsoft Access", "db path", acTable, "temp county", "county"