TXT 转换为ACCESS

来源:百度知道 编辑:UC知道 时间:2024/06/05 09:59:19
文件格式如下:

"","",T-F1-B,H-F1-B,"A3,P-F1-B",""
1,4/1/09 1:00:15 AM,23.7,57.0,111.8,0
2,4/1/09 1:05:15 AM,23.8,45.3,111.7,0
3,4/1/09 1:10:15 AM,24.0,48.8,110.5,0
4,4/1/09 1:15:15 AM,24.2,65.6,109.9,0
5,4/1/09 1:20:15 AM,24.3,73.6,110.3,0
6,4/1/09 1:25:15 AM,24.1,53.1,109.9,0
7,4/1/09 1:30:15 AM,23.6,47.5,109.4,0
8,4/1/09 1:35:15 AM,23.2,54.2,109.0,0
9,4/1/09 1:40:15 AM,23.0,66.0,109.9,0
10,4/1/09 1:45:15 AM,23.0,50.0,110.4,0
11,4/1/09 1:50:15 AM,23.0,45.9,110.4,0
12,4/1/09 1:55:15 AM,23.2,51.0,110.8,0
13,4/1/09 2:00:15 AM,23.5,59.4,110.9,0
14,4/1/09 2:05:15 AM,23.8,67.9,110.9,0
15,4/1/09 2:10:15 AM,23.9,49.9,110.4,0
16,4/1/09 2:15:15 AM,24.0,49.9,109.6,0
17,4/1/09 2:20:15 AM,23.7,59.4,109.1,0
18,4/1/09 2:25:15 AM,23.4,67.2,109.6,0
19,4/1/09 2:30:15 AM,23.0,52.3,110.1,0
20,4/1/09 2:35:15 AM,22.9,47.2,110.3,0
用VB实现

首先打开access,然后在access里点击文件-》打开-》找到你的txt。(当然打开的时候文件类型处选择txt,csv,你的文件才能在文件打开对话框显示。)之后他会提示你选择【带分隔符。。。。。。。】-》选【逗号】-》确定就ok了。

下载ACCESS软件 导入