>Hi all,
>just a quick one. Is there an easy to get data from a foxpro table and put it into SQL server. To be exact what I'd like to do is create a database in SQL server with no tables and then simply select * from table1 from forpro and then insert into new table1 in SQL server. I know it can be done using inserts but I potentially have 6-700 fields and don't fancy doing that.
>
>~M

Check out the Upsizing Wizard, particularly the VFPX version.

Tamar