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