creating excel file

hi all,

i am develoing a web project. In my project users upload a excel file than the excel file is read and converted to the dataset than this dataset is saved to the sql server.. for this i am saving file to a directory in my web aplication. but there is a problem, i have to set "write" access to iis user for this directory.

OleDbConnection conn =newOleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExcelFile +"; Extended Properties=Excel 8.0;");

i use the code above for to connect and get datas. i want to save file to buffer and read from there; so i dont have to set any permission for this. Is there a way to that?

[979 byte] By [ibrahimkurt] at [2007-12-23]

«« Problem with loading solutions (using team system)
»» Form Names Not Visible In Title Bar-Access Runtime

# 1

This is just a suggestion in the correct approach to avoid the usage of the OleDB Jet Engine and so of the filesystem, provided I'm not an expert of Office programming.

You should check if there exists some .NET Library which encapsulate Office objects and to check if there's a way to open a document from a Stream by a Load() method that for consistency should be provided.

If the answer is positive, you have a clear receipe: get a stream from the buffer and pass it to some Load() method of an ideal class named Excel.

Mr.BogoMips at 2007-8-30 >

top of Msdn Tech,Feedback for forums and MSDN websites,Off-Topic Posts (Do Not Post Here)...

Feedback for forums and MSDN websites Hot Topic

Feedback for forums and MSDN websites New Topic

Feedback for forums and MSDN websites

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech