How to retrieve information in ms-acess using win32

gube has asked for the wisdom of the Perl Monks concerning the following question:

Hi monks,

We can use word document or excel sheet using win32 module likewise, is it possible to retrieve database information created in MS-ACCESS.

we can use like this Win32::OLE::Const 'Microsoft Access' please help me the code or tell me any other module if presence, i have to retrieve more 5000 fields of information from Access and to check with text document whether the text is present or not.

Thanks in Advance.
Regards,
Gube

Comment on How to retrieve information in ms-acess using win32

Replies are listed 'Best First'.
Re: How to retrieve information in ms-acess using win32 by Joost (Canon) on Mar 11, 2005 at 12:38 UTC
Take a look at DBI and DBD::ODBC. and maybe read this. "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply]
Re: How to retrieve information in ms-acess using win32 by LanceDeeply (Chaplain) on Mar 11, 2005 at 15:12 UTC
gube- Here are some examples to get you started on dbi: Reading from a database DBI recipes you will also have to figure out how to connect to your MS Access db. here are two ways: you can setup a dsn on your computer that points to your mdb file or you can explicity specify the file in the connect method. checkout google for examples -hth	[reply]