Thanks,

I will do some investigating into your suggestion and may get back to you later.

>Greg,
>
>It's simpler to do this from the SQL side. You can either:
>1) use SQL Server Integration Services (the 2005 version of DTS) to convert the data through an OLE DB or ODBC connection; or
>2) utilize SQL-SMO (the 2005 version of SQL-DMO) in a VFP module that handles the task; or
>3) handle this manually with a sproc/query that accesses the VFP data through OLE DB using the OPENROWSET statement.
>
>Check out the SQL Server 2005 Books Online for assistance with each of these, or you can message me privately for more info.
>
>HTH.
>
>>Hi All,
>>
>>We are looking to convert or clients VFP table (and database) to SQL Server 2005. The problem is that the Upsize Wizard converts the table to SQL Server version 6.5 compatibility. SQL Server has a problem reading 6.5 databases. Does anyone know a tool that can upsize VFP tables to SQL Server 2005?
>>
>>Thanks