cannot able to export excel file to sql server using c#

Question

0.00/5 (No votes)

See more:

hi friends

I have tried in google for my problem with hour and hour. but i am not able to solve my problem.

first:
I am using
1)windows 8(64 bit) 2)visual studio 2010 (X86) 3) sql server 2008 (64 bit) 4)Ms office (32 bit).

I installed Accessdatabaseengine (32 bit) because i cannot able to install 64 bit.

My Error is

OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

also i change the following in sq server

exec sp_configure 'show advanced options', 1
  reconfigure
  GO  
exec sp_configure 'Ad Hoc Distributed Queries', 1 
 reconfigure

Posted 23-Jul-13 22:02pm

baskaran chellasamy

Add a Solution

Comments

Sushil Mate 24-Jul-13 4:33am

whats the issue exactly? you cant install 64bit or you cant export excel to sql?

baskaran chellasamy 24-Jul-13 4:40am

i cant install 64 bit databaseaccessengin 64 bit

Thanks7872 24-Jul-13 4:50am

Use Reply button[like i did by this comment] in order to let the one know about your comment.

Sushil Mate 24-Jul-13 4:54am

how about installing the 64 bit MS office. then try installing the 64 bir database access engine?

Sushil Mate 24-Jul-13 5:41am

below Guirec's solution is not working.

baskaran chellasamy 24-Jul-13 8:43am

I have installed accessdatabase engine 64 bit after uninstall all the 32 bit msoffice. now i check the query based on this
<pr>
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=c:\generalholiday.xls','select * from [sheet1$]')
</pre>
I provide the network service to this excel file.but this error still occur
<pre>
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "The Microsoft Access database engine could not find the object 'sheet1$'. Make sure the object exists and that you spell its name and the path name correctly. If 'sheet1$' is not a local object, check your network connection or contact the server administrator.".
</pre>

baskaran chellasamy 24-Jul-13 5:39am

sorry i dont have the office 64 bit. so please tell any other way. my primary goal is upload the excel file to sql server using c# application

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Guirec · Answer 1 · 2013-07-23T22:50:00

You must firm-up the specs/scope of your problem:

if you want to import data from XL files within Sql Server using CSharp then :
you don't need MS Office
you don't need Accessdatabaseengine
and you should probably not use the OLE DB driver but the native sql server one...

To read your XL data:
use a library like (the excellent) ClosedXML[^]

Once the data is read you soimply do very classic Insert/Updates to your sql server table(s)