Are you just pushing the data to SQL Server one time, or are you going keep using local and remote data with repeated pushes?
Using remote data is not that tough, if you started with views on the front end.
You can push data to the SQL Server via sqlconnect() & sqlexecute()
__Stephen
>Hi there,
>
>I am in the process of troublshooting a system that converts foxpro data to SQL format using a VB program. It seems like a tedious process when I know that SQL has the capabilities of upsizing from Foxpro. I would like to know from anyone who has upsized what type of problems were encountered.
>
>Also if anyone knows of any 3rd party products that migrate the data from Foxpro to SQL in an easy fashion could you please let me know? Thanks.