On 03/14/2017 01:59 PM, Xristos Xristoou wrote: > I have a database in microsoft ACCESS with about 150 records.. if I > want to get some data from this database using a query in python and > i want to store in some variables in python that will do this ? to > avoid the 150 if ...: Using the standard library the python? know > easily put it an SQL query but i canot use additional library > python.
If you simply want to move data to an sql server, your best bet is to use mdbtools to dump the database schema and records out to an .sql file that you can then massage and import into whatever sql server you are using. https://github.com/brianb/mdbtools If you're looking for a way to use the access file directly, and continue using it in MS Access, you might be able to get the odbc bridge working (on windows of course), and communicate with it with pyodbc. -- https://mail.python.org/mailman/listinfo/python-list
