Hello Monks, I'm very familar with DBI. I would like to write a script that would get into MSAccess select certain data out of a table and store it into array variables. then access SQL Server 2000 into a DB and grab another set of data. Finally combine the data into a pipe(|) delimited report. I have DBA background. I just need to know how to connect successfully to MSAccess & SQL Server 2000 to grab the data that I need to create the report. Could you point me in the right direction to look for information about it? or if you have a snippet that I may be able to use to accomplish this task as well. I appreciate your help. Thanks!

In reply to Accessing Access DB with DBI by skyler

Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":