rpike has asked for the
wisdom of the Perl Monks concerning the following question:
I have a mdb access data file. I want to open the access database and parse through it (in code). I have no other information on the file except it's an access database and that's it - given to me from someone else. How can I open the access database in perl (a simple example would be nice to get started - open a connection for example)?
I've seen some examples on the web already, one is where you need to specify a dsn (using DBI). How can I determine what is dsns are available to me (on my system) for this parameter? Setting up the connection is my first hurdle, if I can determine how/what I need to do that for starters would be great. Can anyone suggest an approach to take to make a connection to an access database and how to figure out what I need to pass as parameters?
The mdb is C:/Temp/AccessDB/somename.mdb.