You can rename columns after import, in VFP (with ALTER TABLE, or COPY STRUCTURE EXTENDED). You can also make a copy of the Excel file (assuming you want to keep the original file), and delete unwanted columns, and rename others, before the import. In this case, you would use Automation.

If you want to let the user select columns, it is probably easier to do the changes after importing into VFP.

>Thanks for the reply Hillmar,
>i am not creating Excel file with copy to .... xls . This file allready created by Excel Manually not by VFP . i wantto import or select some columns from it for user choice
>
>excel file looks like below
>
>

>A             B       C      D           E           F          G          H
>Customer      Order   Price  15.09.2003  16.09.2003  17.09.2003 18.09.2003 20.09.2003
>Hillmar       H1      3.59         2000        1000         300        400        100
>Soykanr       S1      3.59         3000        6000         500        200        300
>

>
>for eg i wantto import or select customer,order,price and between 17.09.2003 and 18.09.2003
>imported or select fields should be
>customer,order,price,17.09.2003,18.09.2003 more correct A,B,C,F,G columns not others.
>
>how can possible my thing ? is it possible to rename A,B,C... column names to Customer,Order,Price,17.09.2003,18.09.2003 after import process ? or select SQL containings matches columns ?
>
>TIA