>I haven't use the Upsize Wizard with SQL 7.
>
>Are you sure you have "create table access" in TempDb? This database is usually reserved to the administrator.

Ok, create an empty database and gave myself all rights (I log on to the server using PCA with full admin rights, test using a seperate client running VFP). I set the size of the database and log file and set file growth to 10 percent and checked unrestricted file growth. Then I tried an Import from SQL server rather than an upsize from VFP. It bombs with a message:

Invalid character value for cast specification

I'm assuming this means there is some type casting problem with the field mappings, but the error doesn't give me enough detail.

I'll try the VFP Upsize again now with the new database. Thanks for the tip about checking rights.
>
>Try creating a new empty database and running the upsize wizard against this new database.
>
>
>
>>I'm trying to upsize a VFP table into SQL Server 7. I have all the necessary rights, and am trying to upsize a table in a DBC to the Tempdb database to run some tests in SQL server. I get the following error:
>>
>>To upsize to SQL Server 6.x, please install a SQL Server ODBC driver version 2.05 or later
>>
>>First off, it's SQL Server 7. Secondly, I check the ODBC drivers and found:
>>
>>Microsoft SQL Server ODBC Driver Version 03.70.0623
>>
>>What am I missing here?