excel文件读取写到SQL表里如下,完全正确
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;" & _
"Data Source=" & txtFile.Text & ";Extended Properties='Excel 8.0;HDR=No;IMEX=1'"SELECT * INTO [odbc;Driver={SQL Server};UID=sa;PWD=sasa;Server=test;Database=AIS20100125194525].t201083121450 FROM [query1]但txt文件就不行,为什么?
txtFile.Text = "C:\Documents and Settings\administrator\桌面\"
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;" & _
"Data Source=" & txtFile.Text & ";Extended Properties='Text;HDR=YES;FMT=Delimited'"
SELECT * INTO [odbc;Driver={SQLServer};UID=sa;PWD=sasa;Server=test;Database=AIS20100125194525].t201083121450 FROM 1.txt请教高手,是哪写错了吗?还是这种方式不行?前提不想用读文件或循环的形式来写表,就想一次写入。
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;" & _
"Data Source=" & txtFile.Text & ";Extended Properties='Excel 8.0;HDR=No;IMEX=1'"SELECT * INTO [odbc;Driver={SQL Server};UID=sa;PWD=sasa;Server=test;Database=AIS20100125194525].t201083121450 FROM [query1]但txt文件就不行,为什么?
txtFile.Text = "C:\Documents and Settings\administrator\桌面\"
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;" & _
"Data Source=" & txtFile.Text & ";Extended Properties='Text;HDR=YES;FMT=Delimited'"
SELECT * INTO [odbc;Driver={SQLServer};UID=sa;PWD=sasa;Server=test;Database=AIS20100125194525].t201083121450 FROM 1.txt请教高手,是哪写错了吗?还是这种方式不行?前提不想用读文件或循环的形式来写表,就想一次写入。
看看
http://sqlserver2000.databases.aspfaq.com/how-do-i-load-text-or-csv-file-data-into-sql-server.html
Set Wb = WorkBooks.OpenText(txtFile.Text)
Cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=" & Wb
……
Wb.Close False
SELECT * INTO [odbc;Driver={SQL Server};UID=sa;PWD=sasa;Server=test;Database=AIS20100125194525].t201083121450
FROM 什么?是[query1]?还是什么?