Import Title of column from MS EXCEL

[Mistral2]

When I import from MS EXCEL to foxpro:

IMPORT FROM MyFile.XLS TYPE XL8 SHEET " SHEET1 "

I get MyFile.dbf where the fields are called (a,b,c etc....) instead of the name of the columns of my MyFile.XLS.

Thank you

 

[baltman]

Ask your question in forum1251.

The short answer is that you can read the values imported in row 1 and use ALTER TABLE DBF() RENAME COLUMN A to XXX.

Brian