TransferDatabase

[Guest]

I am using the following code and the API call code from Ken Getz,

DoCmd.TransferDatabase acImport, "Microsoft Access", TestIt, acTable,
"MasterSheet", "MasterSheet"

when I run the code I get a Run-time error, "3001" invalid argument. any
help on this would be much appreciated.

 

[Ken Snell \(MVP\)]

You're using a variable named TestIt as the string that contains the full
path and file name of the database from which you wish to do the import?
What is the value of TestIt?

 

[Guest]

Thaky you, I lost a DIm statement when I pasted the API code.