>>so anyone knows other methods of transfering foxpro to SQL apart from those two methods

If you use AFIELDS(), generating INSERT INTO statements in VFP is pretty simple.
I wrote a utility that creates a SQL Server table from a VFP table and I've used it hundreds of times.
You can write your own in less than an hour and it will be a good investment.
If you get stuck, email me and I'll send you mine, but doing it yourself will give you more control of it.