Access large CSV file with python as a database( adodb way)

A forum for general discussion of the Python programming language.

Access large CSV file with python as a database( adodb way)

Postby sunanda500 » Mon Jan 13, 2014 7:00 pm

Hi all ,

I am finding it difficult to access a CSV file as a adodb connection in Python , so that i can execute sql statement to access data based on conditions. Can anyone help.
Last edited by stranac on Mon Jan 13, 2014 7:01 pm, edited 1 time in total.
Reason: First post lock.
sunanda500
 
Posts: 2
Joined: Mon Jan 13, 2014 6:48 pm

Re: Access large CSV file with python as a database( adodb w

Postby stranac » Mon Jan 13, 2014 7:13 pm

What have you tried?
What errors are you getting?
Friendship is magic!

R.I.P. Tracy M. You will be missed.
User avatar
stranac
 
Posts: 1137
Joined: Thu Feb 07, 2013 3:42 pm

Re: Access large CSV file with python as a database( adodb w

Postby sunanda500 » Mon Jan 13, 2014 7:25 pm

Was trying to use this below format
Excel (using ODBC) Driver={Microsoft Excel Driver (*.xls)};DriverID=790;Dbq=C:\path\to\spreadsheet;DefaultDir=C:\path\to\defaultdir
Excel (using OLE DB) Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Path\To\sheet.xls;

Didnt work as error was unable to load Microsoft Excel Driver.
However my idea was to find a connect string that would work for CSV file.
I ma a novice in Python, hence need your assistance.

With Regards
Sunanda
sunanda500
 
Posts: 2
Joined: Mon Jan 13, 2014 6:48 pm


Return to General Discussions

Who is online

Users browsing this forum: Bing [Bot] and 2 guests