Struggling with FoxPro dbf import

[Noel]

I struggling here!

For the life of me, I can't seem to manually (File>Get External Data....)link/import a foxpro dbf into access (I get the error: 'external table is not in the expected format'), but more importantly/ideally, I'd like to use the TransferData method to import the dbf.

I have been through this entire forum, it seems, and have tried virtually all the solutions that seemed to work for others, but I'm still struggling.

"DoCmd.TransferDatabase acImport, "dbase iv", "C:\Mydir", acTable, "J_SUMRY.dbf", "TEMP""

With the above, I continue to get the "External table is not in the expected format"

"DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;DSN=Visual FoxPro Tables;UID=;SourceDB=C:\Lifetouch;SourceType=DBF;Exclusive=No;Background Fetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;DATABASE=", acTable, "J_SUMRY", "TEMP", False"

With the above, I get the "Microsoft Jet engine could not find the object "TEMP""

I have MDAC 2.8 (office pro 2003), I downloaded and installed "VFPODBC.msi"....

The ODBC driver info I have in 'administrative tools>Data Sources (ODBC)' is the following:
Microsoft FoxPro VFP Driver (*.dbf) and Microsoft Visual FoxPro Driver.
Both are version: 6.01.8629.01, filename: VFPODBC.DLL, dated: 12/7/1999.

This is very frustrating, I can barely breath.

Thank you in advance for any assistance.

Noel

 

[Noel]

odbc driver

I discovered a web page that that the version I have is the current version. SO, I'm still perplexed why the transferdatabase methods I'm using are not working either as "dbase iv" or "odbc".

Any help would be really really appreciated.

Thanks.

Noel

 

[modest]

Database bloat is something we are trying to minimize in order to provide fast searches throughout the forum. Please do not post the same question multiple times. It turns people away rather then have them help you. If you haven't seen a response in a day or two, give it a bump. But there is no need to repeatedly spam your question.

 

[Noel]

sorry

The duplicate thread must have been a glitch in your system or is captured a submit click before and after it requested me to log on.

Anyways, I have found the answer I needed to get the transferdatabase method to work with ODBC.

Thanks.

Noel

 

[Jon K]

Glad you have found a solution.

Could you share it with us. Thanks.
.

 

[modest]

Yes, please share. I was under the assumption that you had already created an ODBC driver and established the connection. So the fault was not in the table itself?

I'm curious to see what was wrong and how it could be fixed.

 

[Noel]

see new post

see new post called "foxpro dbf import solution"
http://www.access-programmers.co.uk/forums/showthread.php?t=127580

Thanks.

Noel