>If you can't do it using Naomi's method let me know and I'll post some VFP code that converts any table from VFP to SQL Server.
>
>

Thanks, Naomi's way works, but I would still like to see your code if you wouldn't mind. I always find the upsizing wizard is a pain and even tried the new sedna one which is what has caused this mess