开发者

Read data from uploaded excel

开发者 https://www.devze.com 2022-12-31 04:42 出处:网络
I need to create an ASP.NET 2.0+ web application that allows the user to upload some excel files; the contents from these files should be saved into some SQL database. The problem is with the connecti

I need to create an ASP.NET 2.0+ web application that allows the user to upload some excel files; the contents from these files should be saved into some SQL database. The problem is with the connection string one should use in ADO.NET. According to this entry (and few others from SO), one has to specify the physical path to the Excel file. This supposes that during data load, the excel file should be saved on the server's harddisk, which in my case is questionable - I can't save temporary files on hdd... Is there any other approach? like using a MemoryStream 开发者_StackOverflowor so?

Thanks


I think you will make life quite difficult for yourself if you were to stream the file, I don't even know if that is possible with Excel via ADO.NET.

I've always worked with excel documents by reading them off the physical drive - are sure you cant store the excel files temporarily?

0

精彩评论

暂无评论...
验证码 换一张
取 消