| |

VerySource

 Forgot password?
 Register
Search
View: 21|Reply: 9

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

[Copy link]

2

Threads

7

Posts

8

Credits

Newbie

Rank: 1

Credits
8

 China

Post time: 2020-1-5 00:50:01
| Show all posts |Read mode
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%
Reply

Use magic Report

2

Threads

7

Posts

8

Credits

Newbie

Rank: 1

Credits
8

 China

 Author| Post time: 2020-1-18 13:45:01
| Show all posts
Why no one answered
thank you
Ask for help
Reply

Use magic Report

0

Threads

12

Posts

9

Credits

Newbie

Rank: 1

Credits
9

 China

Post time: 2020-1-19 23:45:01
| Show all posts
import from 1.lxs type xl5
Reply

Use magic Report

0

Threads

11

Posts

10

Credits

Newbie

Rank: 1

Credits
10

 Singapore

Post time: 2020-1-28 10:45:01
| Show all posts
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.
Reply

Use magic Report

2

Threads

7

Posts

8

Credits

Newbie

Rank: 1

Credits
8

 China

 Author| Post time: 2020-2-1 21:36:01
| Show all posts
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
Reply

Use magic Report

0

Threads

4

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-2-15 22:45:01
| Show all posts
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
Reply

Use magic Report

0

Threads

4

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-2-15 23:30:01
| Show all posts
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
Reply

Use magic Report

2

Threads

7

Posts

8

Credits

Newbie

Rank: 1

Credits
8

 China

 Author| Post time: 2020-4-14 22:00:01
| Show all posts
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?
Reply

Use magic Report

2

Threads

7

Posts

8

Credits

Newbie

Rank: 1

Credits
8

 China

 Author| Post time: 2020-4-15 01:00:01
| Show all posts
Help
Thanks master
Reply

Use magic Report

2

Threads

7

Posts

8

Credits

Newbie

Rank: 1

Credits
8

 China

 Author| Post time: 2020-5-22 10:15:02
| Show all posts
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
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list