[AccessD] Table Transfer Issue

Hi John

Try with:

DoCmd.TransferDatabase acImport, "Microsoft Access", Me.cboImportTable.Column(1), acTable, "KeyProcessAreas", "KeyProcessAreas1"

/gustav

>>> joeget at vgernet.net 19-01-2006 10:07 >>>
 am trying to transfer a table (with the same name) from a different access database to the access database that I have presently open.  I have stored the location of the different access database name in a table.  I display and select the table on the form I have open in a combo box titled cboImportTable.  The bound column is correctly identified and displayed as 1.  Table name to transfer is KeyProcessAreas  

I am using the following code but keep getting a popup that states  "error number 424" and further states "error desc: object required"    I am using the following code 

DoCmd.TransferDatabase acImport, "Microsoft Access", Me.cboImportTable.Column(1), acTable, Me.cboImportTable.Column(1).[KeyProcessAreas], Me.cboImportTable.Column(1).[KeyProcessAreas1]

Column 1 of the table has the full name of the table location in it.

Have an idea what I am doing wrong?

Thanks

John