With ODBC, I can open Access and import a VFP database in a couple of easy steps, and maintain long table and field names - I can't find a way to do the reverse.
I have a state database consiting of over 250 tables that needs to be imported and converted each month. Currently the VFP-to-Access method works great, but there are plans to start sending out the data in Access format, and all my reports and data management stuff are in Fox.
Any suggestions?
Design for the future. Live for the present.