摘要：
代码文件=“c:temp-test.csv”；DataSets=newDataSet（）；stringfilePath=file.Substring（0，file.LastIndexOf（“\\”）+1）；使用（OleDbConnectionconn=newOleDbConnection（string.Format（@“Provider=Microsoft.Jet.OLEDB.4。
代码file="c:\\temp\test.csv";
DataSet ds = new DataSet();
string filePath = file.Substring(0, file.LastIndexOf("\\") + 1);
using (OleDbConnection conn = new OleDbConnection(string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Text;'", filePath)))
{
OleDbDataAdapter adp = new OleDbDataAdapter(string.Format("SELECT * FROM [{0}]", file.Replace(filePath, "")), conn);
try
{
adp.Fill(ds, "clbm");
}
catch
{
}
}
DataSet ds = new DataSet();
string filePath = file.Substring(0, file.LastIndexOf("\\") + 1);
using (OleDbConnection conn = new OleDbConnection(string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Text;'", filePath)))
{
OleDbDataAdapter adp = new OleDbDataAdapter(string.Format("SELECT * FROM [{0}]", file.Replace(filePath, "")), conn);
try
{
adp.Fill(ds, "clbm");
}
catch
{
}
}