ACE 64 bit

[Gerhard]

Can you please tell me how to accomplish the following code on a 64 bit
operating system (Windows 2003 for 64 bit) without having to have IIS run in
32 bit mode? It works fine on a 32 bit operating system.

Thanks.


string connectionString =
("Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=") + filename + ";" +
"Extended Properties=Excel 12.0;";

string strSQL = "SELECT * FROM [Sheet1$]";
OleDbConnection conn = new OleDbConnection(connectionString);
OleDbCommand cmd = new OleDbCommand(strSQL, conn);
conn.Open();
OleDbDataReader myReader = cmd.ExecuteReader();

 

[Gerhard]

Thanks.

That's what I was afraid of...

I wanted to use it in a web part where Excel Services did not fit the need.