阅读Excel Fie Record [英] Reading Excel Fie Record

问题描述

请告诉我所有方法：我如何在sql server表中写入大量的excel记录。我的记录高达90k，有些时间超过



我遵循哪种方法给我最好的表现。现在我正在使用sqlbulkcopy。



此外我将该记录存储在xml中，然后我将其存储在db中，所以现在我想优化我的代码和时间复杂度。 />


问候



Murtaza Malik

Please tell me the all ways : How i write large amount of excel record in sql server table. my records are upto 90k and some time exceed

Which method i follow that give me best performance. Now i m using sqlbulkcopy.

Also i store that record in xml and then i store it in db so now i wants to optimize my code and also time complexity.

Regards

Murtaza Malik

推荐答案

不要将记录存储在XML文件中，因为不必要的XML节点会使源文件变大。而是使用分隔的文本文件（csv或固定长度等）来存储（导出）数据。



您可以设计一个SSIS包来将记录导入数据库。 SSIS拥有多种控件，可以为您提供更多自由和更好的工作设施。

Do not store the records in XML file as unnecessary XML nodes will make your source file bigger. Rather use a delimited text files (csv, or fixed length etc) to store(export) the data.

You can design a SSIS package to import the records to database. SSIS has various number of controls that will give you more freedom and facilities to do your job in better fashion.

这篇关于阅读Excel Fie Record的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！