excel上传到数据库 [英] excel upload to database

问题描述

嗨
请有人帮助我。

我需要将excel数据上传到数据库，但在上传之前需要检查是否是插入或更新。我需要检查每一行。

请分享一些教程...



谢谢

Priyanka

Hi Please someone help me.
I need to upload excel data's to database, but before uploading need to check whether it is insertion or updation. This i need to check for each and every rows.
Kindly share me some tutorials...

Thanks
Priyanka

推荐答案

根据现有行，用于INSERT或UPDATE的术语是 UPSERT 。



有很多关于如何从Excel中追加数据的例子。例如，请看一下： http://stackoverflow.com/问题/ 22273071 / upsert-into-sql-server-from-an-excel-file [ ^ ]

The term used for either INSERT or UPDATE depending on the existing rows is UPSERT.

There are quite a lot of examples concerning how to upsert data from Excel. For example have a look at this: http://stackoverflow.com/questions/22273071/upsert-into-sql-server-from-an-excel-file[^]

这篇关于excel上传到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！