>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
I think you can set up a link to foxpro as a linked server in SQL and then just select from that into your table.
I can't recheck this as I'm not on a site with any fox data at the moment.
http://ask.sqlservercentral.com/questions/1651/link-server-to-fox-dbf-from-sql-2008-server-x64.htmlNick