string source = "Driver={Microsoft Excel Driver (*.xls)};DBQ=d:\\del.xls";
OdbcConnection conn = new OdbcConnection(source);
conn.Open();以上代码是连接数据库del.xls。
请问:
1、为什么不需要在“ODBC数据源”添加数据源?
2、和XLS文件的连接字符串的格式一定是
"Driver={Microsoft Excel Driver (*.xls)};DBQ=d:\\del.xls"
这样的吗?
OdbcConnection conn = new OdbcConnection(source);
conn.Open();以上代码是连接数据库del.xls。
请问:
1、为什么不需要在“ODBC数据源”添加数据源?
2、和XLS文件的连接字符串的格式一定是
"Driver={Microsoft Excel Driver (*.xls)};DBQ=d:\\del.xls"
这样的吗?
using System.Data.Odbc;class Test
{
static int Main()
{
// Console.WriteLine("Hello, World!");
// Console.ReadLine();
string source = "Driver={Microsoft Excel Driver (*.xls)};DBQ=d:\\del.xls";
// string source = "Driver={Microsoft Access Driver (*.mdb)};DBQ=d:\\test.mdb";
OdbcConnection conn = new OdbcConnection(source);
conn.Open();
string select = "select * from [Sheet21$]";
OdbcCommand cmd = new OdbcCommand(select, conn);
OdbcDataReader read = cmd.ExecuteReader();
while(read.Read())
{
Console.WriteLine("{0}, {1}, {2}, {3}", read.GetString(0), read.GetString(1),
read.GetString(2), read.GetString(3));
}
read.Close();
conn.Close();
return 0;
}
}