17,741
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
lizhyifeng2 2005-02-16
- 打赏
- 举报
mark
萧氏 2004-12-12
- 打赏
- 举报
我在SQL查询分析器里能用，但是在。NET里就报没有MSDASQL
chinchy 2004-07-17
- 打赏
- 举报
跟处理文本文件一样处理就得了
wangsaokui 2004-07-16
- 打赏
- 举报
Importing CSV files [C#/Delphi/SQL Server]
On a project that I was recently working on, I was faced with the task of having to import CSV files into an SQL Server database. Just before starting off on writing a custom class to import from CSV, I stumble across a simple way of importing data directly into SQL Server:
SELECT *
INTO theImportTable
FROM
OPENROWSET('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=D:\;Extensions=CSV;',
'SELECT * FROM CSVFile.csv')
On a project that I was recently working on, I was faced with the task of having to import CSV files into an SQL Server database. Just before starting off on writing a custom class to import from CSV, I stumble across a simple way of importing data directly into SQL Server:
SELECT *
INTO theImportTable
FROM
OPENROWSET('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=D:\;Extensions=CSV;',
'SELECT * FROM CSVFile.csv')
athossmth 2004-07-16
- 打赏
- 举报
csv文件不是可以用excel读么？跟excel文件一样的阿
我和我的蓝天白云 2004-07-16
- 打赏
- 举报
好象没有？我不知道
