General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Hi,
>>
>>I'm re-writing an Access app in VFP and I wonder if there's a way to programmatically create .dbfs of all the tables in the database.
>>
>>I suppose I could run something in VFP *or* in Access... either way, the desired end result would be VFP or FP dbfs.
>>
>>TIA
>
>You could either export each table in access to a DBF or create remote views in VFP and transfer the data to VFP tables from there. Another alternative is to use ODBC and SQLStringConnect to the MDB and SQLExec to SELECT all the records from tables into cursors. Then transfer the data to VFP tables.
>
>I assume this is a 1 shot data conversion once you go live with the app, so I would not put a whole lot of effort in getting fancy with the transfer of data.
Right, this is a one-shot export. But, I'm writing the program (or macro or whatever) on my home PC, then I want to just take that program to the client and run it, so their most current data is exported to DBFs.
I *discovered* the TransferDatabase macro in Access and created one macro to Transfer all files... worked well until it found an Access table having two columns with the same name, this file would not successfully export
:(
I guess I'll have to physically modify the access tables first to be sure they can be converted (Hell, since I'm working with the table open anyway, I might as well *Export* the darn thing using the Access menu option!)
Maybe I should look at opening the Access tables from VFP as your suggestion explains.
Thanks
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only