create table tablename( province varchar(20),city varchar(100),telfrom7 varchar(30))insert tablename
select * from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};
DefaultDir=c:\;','select * from aa.txt')
select * from tablename
select * from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};
DefaultDir=c:\;','select * from aa.txt')
select * from tablename
如何根据这个字段和刚才表的前7位号码联系起来
在表一中增加PROVINCE,和CITY这两个字段