>Another useful way to do this is to set up an ODBC data source that points to the Excel Sheet and then get a remote view of the sheet. You can set the column types to be anything you like in the view properties and then USE the view and COPY TO a DBF.
>
>Cheers,
>
>Andrew
>
Hi Andrew,
Honestly I never was able to connect to a regular excel file. Could you give a sample. TIA.
Cetin