Updating access data from foxpro
If anyone is interested how to I will post that here.
Overall it is workable and I tried now to improve performance an there is where the problems started.
Move Next Loop Execute an UPDATE and INSERT SQL statement directly off the db_con.
Fox Pro to MS Access Converter is a tool to Convert, Migrate data from Fox Pro Database or DBF files to MS Access Database or from MS Access to Fox Pro Database or DBF files.
I converted the database (over 100 files) and the data (about 2 gig) and that went smoothly.
One more problem : Using an updatable cursor (by setting the properties with cursorsetproperty()) will fail with an error "Access denied for user ''@'') Turning the debug on on the ODBCDRIVER will show as the last statement UPDATE ") Same statement foxpro tries to send.
David is currently serving as a contract tester with the Visual Fox Pro team at Microsoft, testing the data enhancements made to Visual Fox Pro 9 and implementing performance benchmarks such as the Transaction Processing Council's TPC-H.
After connecting to external data, you can also automatically refresh (or update) your Excel workbooks from the original data source whenever the data source is updated with new information.
Connection information is stored in the workbook and can also be stored in a connection file, such as an Office Data Connection (ODC) file (.odc) or a Data Source Name file (.dsn).