>Hi.
>I have a vfp table which I need to popu;late a SQL server table with the data.
>
>Is there any utility around for doing this ?
>(Its Sql ServerCE .. which will be downloaded to a Pocket Pc unit)
>
>Thanks for any help.
>Regards,
>
>Gerard
Gerard,
For first time creation of tables there is DTS in SQL2000 and SSIS in SQL2005. After that to get data from VFP tables anytime you can use OpenRowSet(),OpenDataSource() functions of SQL (must be enabled in SQL2005 either in code or using surface configuration tool) or you can create a linked server.
Cetin