>Hello,
>
>I need to take a sql file (database) and transfer the tables to vfp. Is there any application that does it in a quick way. The problem is that I don't have sql and don't know a thing about how to use it. I only have a client who will by my vfp system only if I tranfer the data.
>
>Any Idea on how to solve it without having to learn to use SQL?
>
>Thank you for any help...
It depends on what you need to do to the data. The quickest way to get data from a SQL table to a VFP table is thru a VFP remote view. You will need to define a connection in your VFP DBC. Once you have done that the view designer will help construct the view. You can then bring all of the records down to a local cursor and copy them to a free table.
Also check out the SQLEXEC function in VFP.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
