in reply to Accessing Access DB with DBI

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...