Share via

Easy way to get SQL Lite data into MS Access or Excel?

Anonymous
2018-02-03T00:00:31+00:00

Hi everyone,

I am an old MS Office amateur. In the past I have been able to use ODBC to import data, but I can't seem to use it with a dataset a friend sent. Its extension is .db and a look at its characters shows the phrase SQL Lite near the very beginning of the file. We actually use SQL at work, but there, they set up SQL Server Management Studio which lets me easily copy down data.

I don't know how often I'll try to hack a SQL Lite db, so I don't want to invest in any software if I can avoid it.

Can someone direct me either to a place that says how to copy SQL Lite data into MS Access and/or Excel (2013), or some cheap or free SQL Lite tool that will export data to MS Office, one way or another?

I have googled on this topic. The problem is not that there isn't any answer, it's that there are millions on SQL and Office.

Thanks if you can help!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. Karl Timmermans 3,685 Reputation points Volunteer Moderator
    2018-02-03T00:18:18+00:00

    Some articles that address your question

    Connecting Excel to SQLite

    http://smallbusiness.chron.com/connecting-excel...

    How to Convert SQLite to Excel

    http://smallbusiness.chron.com/convert-sqlite-e...

    Converting an SQLite database to Access

    https://ericgazoni.wordpress.com/2011/07/26/con...

    Open SQLite db in Microsoft Access?

    https://superuser.com/questions/264510/open-sql...

    Doing a search using the phrase "how to get SQLite data into MS Access" or "how to get SQLite data into MS Excel" (or variations thereof) return no shortage of references on the topic

    5 people found this answer helpful.
    0 comments No comments

Answer accepted by question author

  1. Anonymous
    2018-02-03T12:13:59+00:00

    Ciao,

    I'm Ugo, a volunteer willing to help other Microsoft customers.

    Regarding your question, additionally to Karl advices, I suggest to post your question into Technet SQL forum, where you can find more SQL specific technical competencies.

    https://social.technet.microsoft.com/Forums/sql...

    Please let me know if this helped somehow.

    Ciao

    Ugo

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful