[Tutor] Intro for interfacing with Microsoft Access?

[Kent Johnson]

You have to set up your Access database as an ODBC data source. I can't give you all the details but 
on my Win2k system if I go to Start / Control Panels / Administrative Tools / Data Sources (ODBC) 
that is the place to set it up.

IIRC you give the data source a name. Then in the ODBC driver (the win32all odbc package) you create 
a connection giving it the data source name and probably a user name and password. When it's all set 
up you can use SQL to talk to the database.

You might have to fiddle a bit to get all the pieces set up :-)

It looks like the win32all package uses the Python DB-API so you can read about that (find the 
database SIG at python.org) for some help in how to use it.

I did this long ago from Java so I'm pretty sketchy on the details, maybe someone else is more 
current on it than me.

Kent

Terry Carroll wrote:
> On Fri, 14 Jan 2005, Kent Johnson wrote:
> 
> 
>>A couple of minutes of googling for 'python odbc' finds the ODBC driver
>>that comes with win32all. It seems to have a fairly simple interface.
>>The download from this page has an example:  
>>http://py.vaults.ca/apyllo2.py/D906422565
> 
> 
> Thanks, Kent.  I'm not familiar with OBDC, but I'll look into it.
> 
> 
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> http://mail.python.org/mailman/listinfo/tutor
>