将数据从 csv 文件导入 msaccess 的 Sql 是否正确 [英] is It correct Sql to import data from csv file into msaccess
本文介绍了将数据从 csv 文件导入 msaccess 的 Sql 是否正确的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
"INSERT INTO CricketMatch
(FName,LastName,Runs,Matches,Location,DateofMatch,PLayerId)
SELECT
Fname,Lname,Runsby,numberofMatches,MatchLocation,DofMatch,Id
FROM [Text;Data Source=C:\\DB\\;HDR=YES].[filename]";
filename 只是扩展名为 demo.csv 的名称,没有路径
filename is just name with extension demo.csv no path
cmd.CDataSet da = new DataSet();string filename = Path.GetFileName(txtCSVFilePath.Text);
try {da = this.ConnectCSV(filename);
string connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\DB\\MatchDetails.accdb";
OleDbConnection conn = new OleDbConnection(connstring);
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;conn.Open();
for (int i = 0; i <= da.Tables["Ss"].Rows.Count - 1; i++){
for (int j = 1; j <= da.Tables["Ss"].Columns.Count - 1;j++){
cmd.CommandText="INSERTINTOCricketMatch(FName,LastName,Runs,Matches,Location,DateofMatch,PLayerId)SELECT(Fname,Lname,Runsby,numberofMatches,MatchLocation,DofMatch,Id) FROM [Text;FMT=Delimited(;);HDR=NO;DATABASE=C:\\DB]." + filename;cmd.Connection = conn; cmd.ExecuteNonQuery();} }}
这就是我正在尝试的
推荐答案
你的语法看起来很接近——尝试这样的事情来连接到 csv 文件:
Your syntax looks pretty close -- try something like this to connect to the csv file:
SELECT Fname,
Lname,
Runsby,
numberofMatches,
MatchLocation,
DofMatch,
Id
FROM [Text;FMT=Delimited;HDR=YES;DATABASE=C:\DB].filename.csv;
这篇关于将数据从 csv 文件导入 msaccess 的 Sql 是否正确的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文