Import a FoxPro table into Access 2003 using a macro

[jabmod]

I am trying to import a FoxPro table into Access 2003 with a macro using TransferDatabase.

Here are my settings:

Transfer Type: "Import"
Database Type: "ODBC Database"
Database Name: Path where the file reside
Object Type: I left this field blank
Source: Name of the file.DBF
Destination: Name of the new table in Access
Structure Only:"NO"


I get the error "Could not find installable ISAM"

What am I missing?

Thanks for your help.

 

[PHV]

Can't you link the dbf ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jabmod]

The foxpro table will be replaced monthly, which is why I need to import the table first before loading it into the master /cummulative table.

If I do a link, I will loose the old data when the table gets replaced.


Thanks

 

[PHV]

I'd use monthly an append query from the linked table.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jabmod]

I am sorry, could you elaborate?

Did you mean to link to the foxpro file and then what?

Thanks
Tolu