二、打开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

相关搜索：