Using perl to manipulate Database

[Naren2585]

Hi everyone
I am new to Perl. My database is in MS.ACCESS. Now i need to write a program in Perl to do any future manipulations to the database.Can any one help me ?

[KevinADC]

As we ask everyone that only posts a set of requirements sans code:

What have you tried so far?

[Naren2585]

Hi
Thanks for the reply..

I am completely new to Perl. I don't even know the packages which i need to install for accessing a MS.ACCESS database.

Can u gimme a brief list of packages ?

[KevinADC]

You need to install DBI and I think DBD::ODBC for Access.

[Naren2585]

Thank you .
I went through a program in the following link which can is similar to the one i have been searching for .

http://bytes.com/serversidescrip ting/perl/tutorials/asimpledatabase program/database.txt


But this program has limitations.The constraint is the type of the field being limited to text.My database is bio-related . It contains sequences of proteins and DNA . Can u suggest some changes so that the limitations can be overcome?

[KevinADC]

Thank you .
I went through a program in the following link which can is similar to the one i have been searching for .

http://bytes.com/serversidescrip ting/perl/tutorials/asimpledatabase program/database.txt


But this program has limitations.The constraint is the type of the field being limited to text.My database is bio-related . It contains sequences of proteins and DNA . Can u suggest some changes so that the limitations can be overcome?

Sorry, there is no way I am going to look through all that code and try and suggest changes. Maybe you want to look into BioPerl or search CPAN for Bio modules.

[bytesonfire]

There is a similar post for using MS Access

Using MS Access Database in Perl

Thanks

[Naren2585]

Sorry, there is no way I am going to look through all that code and try and suggest changes. Maybe you want to look into BioPerl or search CPAN for Bio modules.

Hi .. i guess my wish was too much . any ways thank you .