Greg,
For 3rd suggestion check this one (better whole thread) as an example. Remember that SQL2005 surface configuration must be set to enable OpenRowSet for it to work (or from within SQL server):

Re: Upsizing GUID to UniqueIdentifier Thread #1049183 Message #1049327
Re: Updating SQL Server table Thread #994024 Message #994067

Yet another cool way (if you have a chance to do so) is using .Net code with new SqlBulkCopy class.
Cetin

>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