How to connect to database Ms Access through C++ Builder

[ashishsmith]

Project alloted to me is, I have extract data from Ms Access database, massage the data in certain way to store in the sql server database. I also need to create a sql server database. I have to do all these in c++. Can anyone help?

Thank you,

Ashish Smith

 

[2ffat]

You should be able to do both through ADO, Active X, COM, etc. Which version and edition (Personal, Professional, Developer, Enterprise) of Builder do you have?



James P. Cottingham

^{There's no place like 127.0.0.1.
There's no place like 127.0.0.1.}

 

[ashishsmith]

I have C++ Builder6 Enterprise edition.

 

[2ffat]

Then you have everything you need without installing any third-party items. Look at the help files for connecting to MS Office and DBs.

James P. Cottingham

^{There's no place like 127.0.0.1.
There's no place like 127.0.0.1.}