Hov can I import data from db sqlite file to Acces database.

[Geronimo]

I need help with accesing data from the database file, which I found on web.
The database has almost 2 million records, the zipped file is almost 40 MB in size, so I insert a link
Here is the original file: https://rapidshare.io/1OU1/Jednolity...y_baza_JIM.zip
This is some kind of db (sqllite?) database that I do not know with executable file ejim.exe and some librarys.
How do I link an access database to an ejim database.db

I'll be grateful for the hint.

[CJ_London]

look for an appropriate ODBC driver for the db in question. Not used this link before but they provide drivers for a wide range of db's
https://www.progress.com/odbc

once you have found it and installed it you can use the linked table manager to connect to it via the odbc option

[Geronimo]

Thanks for the quick reply. On the given page there are no dedicated ODBC to the SQLlite database, and I read this format from the preview of the db file in notepad and the attached instructions. What ODBC should I choose, after selecting dBase still access does not want to connect to the database

[orange]

Do you know for sure that the zip file contains an Sqlite database?

Several hits with Google using "odbc driver for sqlite".

[Minty]

I think this driver is widely used
http://www.ch-werner.de/sqliteodbc/

[mike60smart]

Hi
Using Excel - Get Data gives you a list of the contents of the eJIM Folder as shown in the attached.

[Geronimo]

Thank You for replies. But I want direct access to the ejim.db file only. I know, the zipped folder contains many various files: exe file, libraries and instructions, and the ejim database.db I think build in sqlite. Why do I think the database is based on sqlite, because on the last page of the manual in pdf there is a screenshot from sqlite studio and the first line of a ejim.db file opened in notepad is SQLite format 3



To mike60smart
I don't really understand what you mean with this file listing:
Using Excel - Get Data gives you a list of the contents of the eJIM Folder as shown in the attached.

[mike60smart]

The image I uploaded is a screenshot of Excel after I used the Get Data option in Excel

[Gicu]

Have you tried to install and use the driver that Minty provided to link to the file?

[Gicu]

Hi Geronimo,
I was able to install SQLLite3 from the link provided by Minty and using the built-in command prompt tool I have exported all tables to csv. I used the instructions in this site to run the exports: https://www.sqlitetutorial.net/sqlit...te-export-csv/
So first you open the SQLLite3 from your start-up, browse for the eJim.db file then at the prompt I issued .tables to list the tables then

.header on
.mode csv
.output jim.csv
SELECT * FROM jim;
.output gestorzy.csv
SELECT * FROM gestorzy;
....
....
.quit

I have zipped the resultant csv files but they are too big to post here (35MB).

Cheers,