Export

[cohans]

I'm a newbie to Foxpro. Is there a way that I can export a Foxpro DB so that I can import (or convert it) to a SQL DB such as MySQL? All I could find were ways to export it to other version of Foxpro. Thanks.

 

[teresas]

Have you looked at the COPY TO command?

Teresa

 

[rgbean]

You can "export" a FoxPro table in a number of different formats - see the HELP file for the EXPORT command and the COPY TO command. Additionally you could use the ODBC drivers to open the .DBF files in whatever environment you are working, and "move" the data into whatever format you have access to.

Rick

 

[DEDMOD]

Surely MySQL will import delimited files. So I'd think if you export the FoxPro file to a delimited file you can import it into MySQL. You should be looking at the COPY TO command to give you the sort of file you need.

Dave Dardinger

 

[cohans]

I will look into these. Will either of these suggestions create the tables for me in the destination DB, or will they have to already exist? I'd like to avoid writing the ddl. Thanks.

 

[rgbean]

No, you'll have to create your own MySQL tables. If this isn't a onetime thing, consider a program like Data Junction - it can convert many file types to other file types.

Rick

 

[cohans]

Thanks. It's a onetime thing.