HighTechTalks DotNet Forums  

Saving Excel workbook in SQL server using c#

Dotnet Academic General Discussions microsoft.public.dotnet.academic


Discuss Saving Excel workbook in SQL server using c# in the Dotnet Academic General Discussions forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Jitender Khanna
 
Posts: n/a

Default Saving Excel workbook in SQL server using c# - 10-10-2005 , 01:43 AM






Could anyone please help me out as to how we can save the excel workbook in
the database and

read it back.

I was able to convert the text files and image files into binary format and
save them to the

DB and finally able to retrive them back in the same format. But was unable
to do same for

the excel object.

Your help will be greatly appreciated.


Thanks,

regards,
jitender


Reply With Quote
  #2  
Old   
Rodney Mullins
 
Posts: n/a

Default Re: Saving Excel workbook in SQL server using c# - 10-18-2005 , 01:15 AM






Jitender,

Have you ever thought of just using DTS to import or export your data into
the SQL server datbase? The import/export wizard will allow you to choose
the excel spreadsheet as a source and specify the sql server as it's final
destination and vice versa.


"Jitender Khanna" <khanna.jitender (AT) gmail (DOT) com> wrote

Quote:
Could anyone please help me out as to how we can save the excel workbook
in
the database and

read it back.

I was able to convert the text files and image files into binary format
and
save them to the

DB and finally able to retrive them back in the same format. But was
unable
to do same for

the excel object.

Your help will be greatly appreciated.


Thanks,

regards,
jitender




Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.