In addition to what everyone else has said, your client could use SQL Server Desktop (developer?) Edition, for development, the CD wich included MSDE 1.0 and SQL Server 7.0 Developer use to be available for about the cost of shipping in the MS site, I don't know if it still is though, this way you can just transport the data through a simple backup - restore operation.

Yet another way is to detach and attach the database with SQL DMO or the query analyzer.
In the SQL Server 7.0 machine you would detach de database from the query analizer (the database must not be in use) like so:

sp_detach_db 'loans'

after copying the files you need to reattach de database to SQL Server 7, again in the query analyzer:

sp_attach_db 'loans', 'c:\mssql7\data\loans_data.mdf','c:\mssql7data\loans_log.ldf'

And finally to attach the database in the VFP / MSDE PC, copy both files(data and log) and from the VFP command Window:

oServer = CreateObject("SQLDMO.SQLServer")
oServer.Connect("(local)", "sa", "")
oServer.AttachDB("loans", ;
"c:\mssql7\data\loans_data.mdf,c:\mssql7data\loans_log.ldf")

>A client of mine is using VS6 (SP5 - enterprise edition), to try and extract some data from SQL-server7 (on a network) so that it can be used with MSDE (VFP front-end) ...