通过VB.NET代码将Excel数据导入SQL Server表的步骤是什么? [英] What are the steps to import excel data to SQL server table via VB.NET code?

问题描述

我是.net语言的新手，最近我开始为非营利性社会组织制作简单的数据输入系统，大部分应用程序已完成！！但是我无法理解通过vb.net编码将excel导入数据库表(sql服务器)的语法或步骤/过程.我想详细解释:-

使用Visual Studio2012.
数据库名称:-测试
表格名称:-人
列名:- id & 名称

使用Microsoft Excel2013.
Excel文件名:- sample.xlsx
列:- localid & 人
Excel文件中大约有2000至3000行数据

(我知道，你们可能曾经感到烦躁/无耻的问题，但是，我试图从很多方面理解相关代码，但没有成功.这是我最后的希望)

我希望你们能帮帮我！！
高度赞赏任何建议！

[e-mail]

解决方案

请看以下链接.它将对您有帮助.
将数据从Excel导入到SQL Server [ ^ ]

I am very new in .net language, Recently i started to make simple data entry system for Non-profit society organisation, most of part of application is done!! but i couldn''t able to understand the syntax or steps/process for importing excel to database table(sql server) through vb.net coding. i like to explain in details:-

Using visual Studio 2012.
database name:- test
table name:- person
columns name:- id & name

Using Microsoft Excel 2013.
Excel file name:- sample.xlsx
Columns:- localid & person
It''s around 2000 to 3000 rows data in a excel file

(I know, you guys may feel irritated/shameless question ever, But, i am tried to understands related codes from many stuffs but no any success done. This is my last hope)

I want you guys to help me out!!
Highly appreciated for any suggestions!!

[e-mail]

解决方案

Hi,
Please look at following link. It will help you.
Import Data from Excel to SQL Server[^]

这篇关于通过VB.NET代码将Excel数据导入SQL Server表的步骤是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！