Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
3 views
in SQL by (6.1k points)
I'm attempting to open a .sqlite file on Windows, however, I do not know how to. Does anyone know any good program for it?

It holds the data for statistical analysis, however, I prefer having a .txt file.

I also have a .spatialite file. Can anyone help me with this?

1 Answer

0 votes
by (12.7k points)

I would recommend using R and the package RSQLite.

#install.packages("RSQLite") #perhaps needed
library("RSQLite")

# connect to the sqlite file
sqlite    <- dbDriver("SQLite")
exampledb <- dbConnect(sqlite,"database.sqlite")

dbListTables(exampledb)

 Kick-start your career in SQL with this perfect SQL Course by Intellipaat now!

Related questions

0 votes
1 answer
0 votes
1 answer
asked Dec 12, 2020 in SQL by Appu (6.1k points)
0 votes
1 answer
0 votes
1 answer

31k questions

32.4k answers

500 comments

693 users

Browse Categories

...