Convert an Excel crosstab into a DBF file

傲世火凤凰

Ask for help
Crossing an Excel
Convert to DBF file
The specific EXCEL table format is
  Time period A B C ...
 10: 00-12: 00 10% 20% 30%
 12: 00-13: 00 25% 15% 20%
  .
  .
  .
  .
Now convert to this table
Time period content percentage
10: 00-12: 00 A 10%

lancelot0229

First convert the excel table to dbf format, create a new table with the following structure, do a loop to take the values ​​from the above table and insert it into the new table

傲世火凤凰

Can you give the code
Thank you

170385215

First build a DBF table, set to JC, this DBF table has the same structure as your EXcel table, then import EXCEL into your table, and then process it.

USE JC
APPEND FFOM EXCEL table name. xls type xl5
lcString1='Select time period'
lcString2=''
lnFieldSum=Fcount('Jc')
For I=2 To lnFieldSum
lcString2=lcString2+lcString1+",'"+Field(I)+"' As content,"+Field(I)+' As percentage From Jc'+Iif(I=lnFieldSum,'',' Union all')
EndFor
&lcString2

傲世火凤凰

o Which of my EXCEL is not fixed, there may be many strong numbers
But I have already achieved the goal by other means
Thank you very much