what i need to do exactly
i have excel sheet with one field(have many records),
i want to convert this excle sheet to dbf,and append new 3 fields,
and insert or replace for those fields data as date ,recno(),and 0.
and convert it again to excel sheet.
all this operations at my textbox.
What error?
error message
ALTER TABLE (thisform.text9.Value) ADD COLUMN date
thanks.
>>Import from (thisform.text9.Value) TYPE xls && i must have table name as text9 name
>>&&thisform.text9.Value=kkk.xls
>>ALTER TABLE (thisform.text9.Value) ADD COLUMN date&&&"kkk.xls" is not a table
>>
>
>What error? In order for someone to help you, that information would be relevant. This will ease the support.