--try select UserID,ViewIP,max(时间) as 时间 from opendatasource('microsoft.jet.oledb.4.0','Text;hdr=yes;database=d:\')...文件名#txt group by UserID,ViewIP--如果查询全部数据 select UserID,ViewIP,* from opendatasource('microsoft.jet.oledb.4.0','Text;hdr=yes;database=d:\')...文件名#txt
select UserID,ViewIP,max(时间) as 时间
from opendatasource('microsoft.jet.oledb.4.0','Text;hdr=yes;database=d:\')...文件名#txt
group by UserID,ViewIP--如果查询全部数据
select UserID,ViewIP,*
from opendatasource('microsoft.jet.oledb.4.0','Text;hdr=yes;database=d:\')...文件名#txt
建立表,设置字段类型
读取TXT文件,插入表