How to achieve the conversion of a cross Excel table into DBF

傲世火凤凰

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%

傲世火凤凰

Why no one answered
thank you
Ask for help

lancelot0229

import from 1.lxs type xl5

kriesscoen

The best way is to open that Excel file directly and then read the data from it and write it into a DBF file.
When it comes to the intersection of data, there are no direct tools.

In fact, it is relatively easy to manipulate Excel spreadsheets from VFP, as long as EXCEL is opened, or
It is very convenient to fill in the blanks, or to fetch the data line by line.

傲世火凤凰

a key this is a cross list
I am a rookie
It's been a long time since I started the program
Pick up again at an age
Oh oh
Enlighten me

holley520

1. import excel file
create table temp (time period c (10), A c (10), b c (10) c c (10))
use temp
append from file name.xls xl5

2. Convert file format
select time period, a from temp into table bak1
select time period, b from temp into table bak2
select time period, c from temp into table bak3

select * from bak1 into table temp
use temp EXCLUSIVE
append from bak2
append from bak3

holley520

It was wrong
1. import excel file
create table temp (time period c (10), A c (10), b c (10) c c (10))
use temp
append from file name.xls xl5

2. Convert file format
select time period, 'a' content, a percentage from temp into table bak1
select time period, 'b' content, b percentage from temp into table bak2
select time period, 'c' content, c percentage from temp into table bak3

select * from bak1 into table temp
use temp EXCLUSIVE
append from bak2
append from bak3

傲世火凤凰

holley520
Thank you
Thanks so much
But I do n’t understand the following lines very well

select time period, 'a' content, a percentage from temp into table bak1

There are a few items I listed at the time
In fact, not only A, B, and C have dozens or hundreds of content
Not sure, what should I do? Do I need a function?

傲世火凤凰

Help
Thanks master

傲世火凤凰

select&amyarray (ncount) from table to array arrssl
Is this statement correct
Where amyarray (ncount) is an array
It contains a field in the table