Import table from another databse 1

[brau]

I have an access project and am trying to import a table from
access97 db. I can import using file/import from the menu but can't
using the following code.

DoCmd.TransferDatabase acImport, , "\\Gaylord1
\Construction\ESTIMATES\MC2\reports\tmpansr.mdb",
acTable, "EDF", "EDF"

I get the following run-time error 2507, "The type isn't an installed
database type or doesn't support the operation you chose."

I there a reference I need to install? I can't find any info on this
error.

thanks, bob

 

[ide]

try this:

DoCmd.TransferDatabase acImport,"Microsoft Access", "\\Gaylord1
\Construction\ESTIMATES\MC2\reports\tmpansr.mdb",
acTable, "EDF", "EDF"

ide (-:

 

[brau]

Perfect. I guess I shouldn't assume that access new that "Microsoft Access" was the default for this field.

Thank you for your help ide.

Bob