Extracting Excel data using Sql connection string

Question

My intention here is to render the excel data in a table, using a datatable, so opened an odbc connection and loaded the datatable like this:

System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection(Dsn=Excel Files;Driver={Microsoft Excel Driver (*.xls)};Driverid=790;Dbq=C:\Users\*******\Documents\Book1.xlsx;DefaultDir=C:\Users\******\Documents;HDR=YES);
conn.Open();
DataTable dataTable = new DataTable();
string con = "select * from [sheet1$]";
System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(con, conn);
System.Data.Odbc.OdbcDataReader dr = cmd.ExecuteReader();
dataTable.Load(dr);

But insted getting an error like this

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

So actually whats' the root cause ?

Are there some quotes missing from your code? Is it C#?

doctorlove
– doctorlove

2013-08-06 09:08:34 +00:00
Commented Aug 6, 2013 at 9:08 — doctorlove
– doctorlove, Commented Aug 6, 2013 at 9:08
Does this help? stackoverflow.com/questions/11365146/…

doctorlove
– doctorlove

2013-08-06 09:09:28 +00:00
Commented Aug 6, 2013 at 9:09 — doctorlove
– doctorlove, Commented Aug 6, 2013 at 9:09

Conrad Lotz · Accepted Answer · 2013-08-06 09:16:03Z

2

Please use the following link as a possible solution to your problem:

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

answered Aug 6, 2013 at 9:16

Conrad Lotz

8,9533 gold badges25 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

joedanny Over a year ago

now everything fine , but when I establish a connection with same connection string above , I got this error "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified "

joedanny Over a year ago

I got the way , yes I was using the DSN which was not found in the ODBC server , so I created the DSN and then utilized it .

Conrad Lotz Over a year ago

Great, glad I could assist!

SliverNinja Over a year ago

Creating a x86 Excel DSN worked for me. Used ODBC Admin to create new "Excel Files x86" DSN. Worked like a charm!

doctorlove · Accepted Answer · 2013-08-06 09:13:23Z

0

This suggests

"changing the Platform target project setting from Any CPU to x86."

will help. The root cause is, as the error says, a mismatch between the database driver and your application.

These docs say

If you use the 64-bit odbcad32.exe to configure or remove a DSN that connects to a 32-bit driver, for example, Driver do Microsoft Access (*.mdb), you will receive the following error message: The specified DSN contains an architecture mismatch between the Driver and Application To resolve this error, use the 32-bit odbcad32.exe to configure or remove the DSN.

answered Aug 6, 2013 at 9:13

doctorlove

19.4k3 gold badges49 silver badges65 bronze badges

Collectives™ on Stack Overflow

Extracting Excel data using Sql connection string

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related