python and databases
Michael Torrie
torriem at gmail.com
Wed Mar 15 11:19:00 EDT 2017
On 03/15/2017 08:45 AM, Xristos Xristoou wrote:
> first thx for response second i cant use additional packate because i
> build tool for other python program and that use standar python
> only,
I don't see how you can retrieve data from MS Access without a tool that
is not part of the standard Python distribution.
> sqlite is in standar python 2.7 @Irmen de Jong ?
Yes. Sqlite3 is built into Python 2.7. However I don't see how it will
help you with an access database. You'd have to convert the data from MS
Access to sql and insert it into the sqlite database.
> can use quyries in CSV @ Irving Duran @Chris Angelico ?
No. CSV is just a data interchange format. It's not a database.
However you could export the entire table from MS Access to CSV and then
with a Python script create an SQLite table and insert records into it
from the CSV file that you load and parse with Python.
More information about the Python-list
mailing list