>>>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.