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.