开发者

Reading Excel Files MSOffice vs Open Office

开发者 https://www.devze.com 2023-02-05 03:53 出处:网络
I have an application the reads excels files and move them to my MS SQL database, via C#. This is a done on a machine that host the MSSQL Server as well as an IIS Arcgis Server. The machine is not ver

I have an application the reads excels files and move them to my MS SQL database, via C#. This is a done on a machine that host the MSSQL Server as well as an IIS Arcgis Server. The machine is not very strong only 3gb of RAM and the prospects开发者_运维技巧 of them giving me a true server seem close to to nil. So I wanted to know which one option is less demanding , memory wise. OpenOffice or MS Excel.


Neither - use the OleDb provider. It's much simpler and faster. But between the two options you proposed, MS Excel is almost certainly going to be less memory intensive.

0

精彩评论

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