I assume you created the Excel file with COPY TO ... TYPE XLS.
For any further control of the spreadsheet, you should use Automation.
Perhaps my introductory article on Automation,
http://www.levelextreme.com/Magazine/September2002/Page45.asp, can help you.
Note: For speed, you should probably first use COPY TO ... TYPE XLS, and only then open the spreadsheet with Automation.
>Hi All,
>i'am importing an excel sheet from excel file and create dbf.. first record containings excel column names , naturally in dbf A,B,C,D goes etc...
>And first record containings excel column names in dbf such as 16.09.2003 17.09.2003 18.09.2003 going on hierarchicaly .
>
>Now i wantto do these steps,
>
>1-first i wantto rename some column names eg S with 15.09.2003 T with 16.09.2003
>
>2-after renaming ,wantto drop some columns as a user entered date ranges ( eg. 15.09.2003 -07.10.2003)
>
>how can i do this ?
>
>TIA
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)