上一页 1 2 3 4 5 6 下一页
二、打开FoxPro，建立两个数据库
1.数据库D:\DBF\LYC1.DBF 结构表:
| Field |
Field Name |
Type |
Width |
|
| 1 |
XH |
Integer |
4 |
序号 |
| 2 |
XM |
Character |
10 |
姓名 |
| 3 |
XB |
Character |
4 |
性别 |
| 4 |
SBBH |
Character |
40 |
社保编号 |
| 5 |
RYFL |
Character |
10 |
人员分类 |
| 6 |
BJ |
Character |
2 |
标记 |
| 7 |
DB |
Character |
20 |
对比 |
| ** Total ** |
91 |
2.数据库D:\DBF\LYC1_1.DBF结构表
| Field |
Field Name |
Type |
Width |
|
| 1 |
XH |
Integer |
4 |
序号 |
| 2 |
XM |
Character |
10 |
姓名 |
| 3 |
XB |
Character |
4 |
性别 |
| 4 |
SBBH |
Character |
40 |
社保编号 |
| 5 |
ZGZ |
Integer |
4 |
在职工资 |
| 6 |
TGZ |
Integer |
4 |
退休工资 |
| 7 |
BJ |
Character |
2 |
标记 |
| 8 |
DB |
Character |
20 |
对比 |
| ** Total ** |
89 |
|
三、加数据到两个数据库
1.将out.txt 导入到lyc1.dbf
sele 1
USE d:\dbf\lyc1.dbf IN 0 EXCLUSIVE
dele all
pack
append from d:\dbf\out.txt fields xm,xb,sbbh,ryfl delimited with ","
brow |
2.将out1.txt 导入到lyc1.dbf (out1.txt来自与医保个人帐户电子文档，分单位，包含个人的姓名、性别、社保编号、在职工资、退休工资等信息)
sele 2
USE d:\dbf\lyc1_1.dbf IN 0 EXCLUSIVE
dele all
pack
append from d:\dbf\out1.txt fields xh,xm,sbbh,zgz,tgz delimited with ","
brow | 上一页 1 2 3 4 5 6 下一页 |
