Importing a FoxPro table using VBA

[MarkGallie]

I'm trying to import a few tables from a FoxPro database into an Access Database using VBA code. I know I have done it before and I remember struggling with the format last time. Can anyone see where I'm going wrong?



DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;DSN=Hiremate;SourceDB=\\data-ww\apps\hmfox32\data\hiremate.dbc;SourceType=DBC;E xclusive=No;BackgroundFetch=Yes;Collate=Machine;Nu ll=Yes;Deleted=Yes", acTable, "hires"

The error I'm receiving is:

Run-time error '3011': The Microsoft Access database engine could not find the object ". Make sure the object exists and that you spell its name and path name correctly.

Which part of the statement is this referring to? The table names and paths are spelt correctly so I assume this is an issue with the format of the statement.

Thanks

[MarkGallie]

Having added quotations around both the DSN and SourceDB strings as follows:

DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;DSN='Hiremate';SourceDB='\\data-ww\apps\hmfox32\data\hiremate.dbc';SourceType=DBC; Exclusive=No;BackgroundFetch=Yes;Collate=Machine;N ull=Yes;Deleted=Yes", acTable, "hires"

I now get the error:

ODBC-Connection to "Hiremate" failed.

However, I know that the connection works as I can perform the import manually.

[cplmckenzie]

MarkGallie,

What version of Foxpro are you using and do you have a sample foxpro file you are using.

cplmckenzie