Import title of column from EXCEL

[Mistral2]

When I import from 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

 

[Mike Lewis]

Mistral2,

Can you use the import wizard for this job? If so, there is an option where you can specify the row number that contains the column names.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[Mistral2]

I use this instruction in a prg

 

[Mike Lewis]

Mistral2,

In that case, one possibility would be to import the table as usual, then use ALTER TABLE to rename the fields according the contents of the first record, then delete the first record.

Another idea would be to do the whole thing through Automation, but that would involve a bit more code.

Mike

Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[Mistral2]

THANK YOU MIKE

 

[danceman]

another thought. if your table format is known, use the append from.

Attitude is Everything