阅读背景:

导入SQL Server数据库的大型Excel文件

来源:互联网 

I have a client who needs to import rows from a LARGE Excel file (72K rows) into their SQL Server database. This file is uploaded by users of the system. Performance became an issue when we tried to upload and process these at the same time on user upload. Now we just save it to the disk and an admin picks it up and splits it into 2K rows and runs it through an upload tool one by one. Is there an easier way to accomplish this without affecting performance or timeouts?I have a client who needs to import rows from a




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: