如何将此文本文件的数据有选择地导入到SQL SERVER不同的数据表中? 给实例,万分感谢了! (5分)

  • 主题发起人 主题发起人 Jenky.w
  • 开始时间 开始时间
J

Jenky.w

Unregistered / Unconfirmed
GUEST, unregistred user!
文本的格式及部分内容为:
"SHIP02","VBS - VBTCP,PC4","02/06/2002","20:22:45","9","C"
"SHIP02","VBS - VBTCP,PC4","02/06/2002","20:33:54","9","C"
"SHIP02","VBS - VBTCP,PC4","02/06/2002","20:36:01","8","C"
"SHIP02","VBS - VBTCP,PC4","02/06/2002","20:36:32","8","C"
"MORV00","VBS - VBTCP,ZJ","02/06/2002","022:39:24","9","C"
"MORV00","VBS - VBTCP,ZJ","02/06/2002","022:39:39","9","C"
"MORV00","VBS - VBTCP,ZJ","02/06/2002","022:39:50","9","C"
"MORV00","VBS - VBTCP,ZJ","02/06/2002","022:40:01","9","C"
"MORV00","VBS - VBTCP,ZJ","02/06/2002","023:36:38","9","C"
"PICK08","VBS - VBTCP,ZJ","02/06/2002","023:37:00","9","C"
"MORV00","VBS - VBTCP,ZJ","02/06/2002","023:37:09","9","C"
"MORV00","VBS - VBTCP,ZJ","02/06/2002","023:37:51","9","C"
"PICK08","VBS - VBTCP,ZJ","02/06/2002","023:38:13","9","C"
然后实现
将此文本文件的数据有选择地导入到SQL SERVER不同的数据表中?
给实例,万分感谢了!
 
选择条件??
 
换个思路行不行?先不怪三七二十一导入,再对数据集进行选择。
 

Similar threads

S
回复
0
查看
3K
SUNSTONE的Delphi笔记
S
S
回复
0
查看
2K
SUNSTONE的Delphi笔记
S
I
回复
0
查看
860
import
I
I
回复
0
查看
700
import
I
I
回复
0
查看
796
import
I
后退
顶部