December 13, 2011 at 11:14 pm
Hi all,
i am using jquery ajax and asp.net(C#) to save data from xls,xlsx,csv to sqlserver2005.
OR
simple using Asp.net(C#) and sqlserver2005(with out jquery)
how it could be?
December 14, 2011 at 12:08 am
You should use SSIS for these tasks. It is a very efficient tools for these kind of tasks.
You can get more information here:
P.S. The example given in this article if for importing data from excel to SQL Server, however similarly you can do the same for csv also.
December 14, 2011 at 12:17 am
Duplicate Post...
http://qa.sqlservercentral.com/Forums/Topic1221358-338-1.aspx
December 14, 2011 at 5:40 am
i have written code and is working fine..now the issue is when i am using to upload to server not on local,then i am geting this error
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.
any help?
December 14, 2011 at 6:05 am
engrshafiq4 (12/14/2011)
i have written code and is working fine..now the issue is when i am using to upload to server not on local,then i am geting this errorThe OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.
any help?
You need to install the ACE provider on the server. Download link is given below:
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734
December 14, 2011 at 6:15 am
i am using discountasp.net server and i got a responce from admin that they do not allow bulk insertion.so what i do now?any other solution?
December 14, 2011 at 6:38 am
engrshafiq4 (12/14/2011)
i am using discountasp.net server and i got a responce from admin that they do not allow bulk insertion.so what i do now?any other solution?
They (who?) do not allow bulk insertion ?? I didn't get you.
What is the actual problem? Could you please tell in detail what you are trying to do & why ?
December 14, 2011 at 7:16 am
engrshafiq4 (12/14/2011)
i am using discountasp.net server and i got a responce from admin that they do not allow bulk insertion.so what i do now?any other solution?
Use SSIS. It comes with SQL Server and it is free if you install it on the same server. And it is made especially to do the tasks you are trying to do.
Do not re-invent the wheel...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 14, 2011 at 7:23 am
If the DBAs don't allow bulk insert or ad hoc queries, which is a common security measure, then SSIS is your best bet.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 14, 2011 at 10:34 pm
i am using ACE provider to insert bulk data from my web application to sqlserver.and the server do not support ACE provider.
December 14, 2011 at 11:10 pm
engrshafiq4 (12/14/2011)
i am using ACE provider to insert bulk data from my web application to sqlserver.and the server do not support ACE provider.
Everybody has suggested you to use SSIS. If you have not used SSIS for these tasks earlier, this is the right time to do it.
December 14, 2011 at 11:14 pm
Hi,
i am using asp.net web application to to upload/save data....now the question is that i can not use SSIS in asp.net.i do not want to use sqlserver alone.i need a replace of
Provider=Microsoft.ACE.OLEDB.12.0;
in my conection string
December 15, 2011 at 12:15 am
engrshafiq4 (12/14/2011)
Hi,i am using asp.net web application to to upload/save data....now the question is that i can not use SSIS in asp.net.i do not want to use sqlserver alone.i need a replace of
Provider=Microsoft.ACE.OLEDB.12.0;
in my conection string
I'll spell it out for you:
n.o. a.s.p.n.e.t.
u.s.e. s.s.i.s. i.n.s.t.e.a.d.
And install the ACE and the JET provider on the server, SSIS will need that too.
If you install the 32-bit version of ACE, make sure your solution (whatever it is) also runs in 32-bit.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 15, 2011 at 6:16 am
engrshafiq4 (12/14/2011)
i am using ACE provider to insert bulk data from my web application to sqlserver.and the server do not support ACE provider.
Then you'll either need to use a different provider, or a different solution.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 15, 2011 at 6:20 am
yes i read xlsx file as xml and passed it to store procedure...i am getting another issue,which i asked here
http://qa.sqlservercentral.com/Forums/Topic1222331-338-1.aspx
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply