How to read excel file and import data into SQLITE database table in C# using visual studio

Question

0.00/5 (No votes)

See more:

Excel-2016

there is a sample data in excel file e.g.

Name    Date     CITY
ABC   01-01-2020  ny
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

XML

ID 
Name  
Date
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

What I have tried:

i did not try anything about it yet.. i am new into sql lite database

Posted 7-Mar-21 21:36pm

Member 14599863

Updated 7-Mar-21 22:21pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2021-03-07T21:54:00

We are more than willing to help those that are stuck: but that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.

So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.

If you are having problems getting started at all, then this may help: How to Write Code to Solve a Problem, A Beginner's Guide[^]
Read it, and then start thinking about what you need to know to do it: read data from an excel file (and how you do that will depend on the file type and software installed on your target machine), convert it to data that SQLite will understand (no guarantees that the dates will be dates or even readable dates-as-a-string unless you convert them to DateTime values), and store to SQLite. Break those tasks down into smaller parts, and you can start working on designing your app, and then coding and testing it.

Richard MacCutchan · Answer 2 · 2021-03-07T22:21:00

Solution 2

See Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^] for importing from Excel into a C# program. For information on SQLite see SQLite Home Page[^] and System.Data.SQLite: Home[^].

Posted 7-Mar-21 22:21pm

Richard MacCutchan