Development Advice Needed

[morechocolate]

I have been asked to create an application that extracts and compares data from two different databases (one is SQL Server and the other is Sybase). Being a novice I am not totally sure how I should go about this.

I am only getting read access to each of the databases so I am going to have to connect to each of the databases, extract the information needed from each and put that data in an Access Database, then use the data that was extracted to Access to do the comparison.

This process is to be run on a monthly basis and the data in each of the non-Access Databases gets updated daily.

At first I was going to have the Access database link to the tables that I need for the two databases, but realized that the link would have to be done each time the program is run. I do not know how to do that.

I also thought about having the VB app extract the data, but then that means I need three providers in my code. Is that good programming?

I just need to know the best way to attack this. Ultimately VB is going to use Access to do the comparison.

Thank You in advance.

Pam

 

[Terpsfan]

One thought is to link within Access to each of the Sybase and SQL Server databases via ODBC. Then you can create queries, forms, reports from those linked tables. Go to the Access front end, go to the Database Window and then Tables tab. Right-click the Tables table and select Link Tables. Then you select ODBC as Files of Type. Link up to you SQL tables and then your Sybase tables. Then in your Database Window you should see the linked tables if all goes well.