import data from excel and pass into table

Mar 8 2021 8:38 AM
there is a sample data in excel file e.g.
  1. Name    Date     CITY  
  2. ABC   01-01-2020  ny  
  3. def   02-03-2020  sa  
now i want to import that excel file through c# code and insert that data into table. ... table is like this. these are the columns in tables
  1. ID   
  2. Name    
  3. Date  
  4. city  
here ID should be auto generate in table

i want to this through c# and sqllite database

so how i import excel file and pass excel file data into table

i did not try anything yet

any solutions


Answers (4)