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();

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.

"Mark Rae [MVP]" wrote:

> "Gerhard" <(E-Mail Removed)> wrote in message
> news:CA9A6C5D-BE38-4844-8759-(E-Mail Removed)...
>
> > 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.
>
> There is no 64-bit driver for ACE. Several options exist, but all of them
> involve 32-bit to a greater or lesser extent:
> http://www.google.co.uk/search?sourc...E+OleDb+64-bit
>
> Why are you using this datasource, AAMOI...?
>
>
> --
> Mark Rae
> ASP.NET MVP
> http://www.markrae.net
>
>