怎么将dat数据文件实时读入到我的Ａｃｅｓｓ数据库表中

wangkaiyi

我有一个实时数据采集的软件，它的数据文件格式为ＤＡＴ，前四行都是
"TOA5","CR1000","CR1000","11649","CR1000.Std.14","CPU:GARD01020.CR1","63495","TenMin"
"TIMESTAMP","RECORD","batt_volt_Min","PTemp","Ta_Avg","RH_Avg","Pvapor_Avg","WS","WD","WD_std","Rain_Tot","T_109_Avg","Rs_Avg","LWS_Avg","LWS_RH","VWC","CO2_Avg","DirRad_Avg","Sunduration_Tot","Evap_Tot","Watlev"
"TS","RN","","","C","%","Kp","m/s","Deg","Deg","mm","C","w/m^2","","","","","","","",""
"","","Min","Smp","Avg","Avg","Avg","WVc,:","WVc,:","WVc,:","Tot","Avg","Avg","Avg","Smp","Smp","Avg","Avg","Tot","Tot","Smp"
前四行都是上面这样，关于采集记录的名称和度量单位等信息，下面是采集的数据记录
"2008-06-15 04:30:00",32199,12.56,18.51,17.93,94.8,1.947,0,0,0,0,22.98,0,256.8,1.068,0.526,364,0,0,0,68.3
"2008-06-15 04:40:00",32200,12.55,18.51,18.01,94.9,1.959,0,0,0,0.2,22.96,0,264.3,1.811,0.525,371.1,0,0,0.021,68.32  
请高手指教怎么将这样的数据文件实时读入到我的Ａｃｅｓｓ数据库表中，先在这里先行谢过了！

ACMAIN_CHM

改成后缀TXT，然后导入即可（可以用TransferText 方法)