>>>>>You and Thomas both misunderstood what I meant.
>>>>>
>>>>>Here is what I wrote
>>>>>

>>>>>CREATE CURSOR Inventory_Locations (Descrip C(10), ExternalId varchar(50), Id I AUTOINC NEXTVALUE 2 UNIQUE)

>>>>
>>>>ROFL
>>>>Oops!
>>>>Sorry.
>>>
>>>Please see my updated reply as I added 2 more questions. To clarify - I created an Excel with 12 sheets. I now want to insert data from these sheets into cursors and add extra column for Row (I call it ID).
>>>
>>>I also want to make sure that if I declare columns as C in VFP, I will not be adding trailing spaces to the values which defined as varchar in SQL - just want to make sure.
>>
>>
>>>By the way, will the spaces be automatically dropped when passing the values back to SQL Server if declared as C(50) in
>>VFP?
>>
>>Nope. Spaces will be there.
>>BTW I don't know how you update SQL Server table.
>
>Using SQLExec. So, do you suggest to use varchar then declaring the columns in the cursor?

No, just use ALLTRIM() when you update.
BTW why you don't want to use varchar?