yes i read xlsx file as xml and passed it to store procedure...i am getting another issue,which i asked here

http://www.sqlservercentral.com/Forums/Topic1222331-338-1.aspx

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...

i am using ACE provider to insert bulk data from my web application to sqlserver.and the server do not support ACE provider.

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?

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...

Worked For me.i saved image.Now please do clear me about image and varbinary max data types.....as both worked for me.wich one ll be better to use?

In my enterprise library i do not have varbinary(max).Here is only binary...would u suggest anything?

YOu right clicked on database ....i just want to export one table and then import that table in another db....i can view like ur attached

yes i am using sql management studio and do not have tasks option

sorry i am mentioning this point that i do not have Click on Tasks > Import Data....i do not have tasks->import/export.....even i do not have tasks

i have created database of that backup...i can view my table and its data too..now i want to get data from here to my server table from where i have...

@SSCrazy

Ok Now i do have that data on another machine on local.i want to export that specific table but there is no export/import options....is there any query to export...

i can changed it to Full but what i do next?i want to recover my lost table data?what i do next...after i have my sqlserver in full mode

i checked it is in simple Recovery Model.Can i change it to FUll?what i should do now?

I am new to https://my.discountasp.net..i can not check wheither it is in full mode or not.can you please check it for if i give you the username and...