You could simply do your work in SQL Server 2000 itself as a DTS package. Have two data sources configured - one for MS access and other for SQL server, 'transform' the data and output to the format you want. Good Luck...

In reply to Re: Accessing Access DB with DBI by dba
in thread Accessing Access DB with DBI by skyler

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