Importing Progress data to SQL Server.

[murLee]

Hi everybody..
I am working on a project which involves communication with Progress database, its actually an Attendance System.
My application is developed in .net(ASP.net/C#) & SQL Server2000, i have to get the data from Progress database at regular intervals. For this i will be writing a DTS,
But i am not sure that i can connect directly to Progress database and get the data to SQL Server using Merant 32 bit driver?
As per some documents they have suggested importing of data to Access/Excel etc.
Please help me ....Is there any drivers available to connect to Progress database? or i have to import into Access then to SQL Server?


Regards,
MurLee

 

[gcampbell]

You can attach to the Progress DB and extract data via ODBC. Then you can connect (within the same procedure) to your MS SQL database and update that database with the record sets from your Progress DB.

Where is your confusion?

Later,
Gordon

 

[murLee]

I want to know does the Progress have the tables in the database & what is the extension?
Does any one have an idea of CCURE attendance system?

Regards,
MurLee