mxODBC: File DSNs?

[M.-A. Lemburg]

Greg Ewing wrote:
> 
> Is there any way of using mxODBC to open a connection
> specified by means of a File DSN?
> 
> If so, how?

Just add the File DSN to your ODBC Manager setup and then point
mxODBC at it using ODBC.Windows.DriverConnect().

This let's you run queries on Excel sheet, CSV files, etc. It's
a pretty nice way of importing raw data into databases, BTW.

-- 
Marc-Andre Lemburg
______________________________________________________________________
Y2000:                                                   123 days left
Business:                                      http://www.lemburg.com/
Python Pages:                           http://www.lemburg.com/python/