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!!
gpt16sagar@gmail.com