Extract data to mdb format

Hi Expert,
  Anyway we can extract the data from db to mdb file format for microsoft access?
mkdev2009Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BALMUKUND KESHAVCommented:
Can you elaborate your question, i mean what is your data source (db) ? and how do you want to convert it into mdb ?

Bm keshav

0
mkdev2009Author Commented:
Hi Keshav,
  My database is MSSQL2005, i need to extrat the data and create it as mdb format. It that possible to work out?
0
BALMUKUND KESHAVCommented:
Download the toll from http://www.topshareware.com/ms-access-to-ms-sql-2005/downloads/1.htm
Try at your own end, b/c i have not used this.

Bm Keshav
0
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

srinivasraorajulalpudiCommented:
you can export the data by following the steps

1) open the sql server 2005
2)in the object explorer select the dtabase or name of the organisation
3)right clik on the database name and select tasks
4) click on the export data.
5) click on the ok and next and slect the datasource as sql from where you want to pick the data
6)now select the destination to Microsoft access. here you  can choose ms excel, etc.

By this way we can export the data .
0
mkdev2009Author Commented:
How about if i want to create a system to extract it to mdb format? insteand of doing it muanually from sql server 2005.
0
srinivasraorajulalpudiCommented:
We can write a windows application in c#, and do that but it has to be executed manually and the progam will be lengthy, like accessing each and every table of the db and cross checking it and saving the file to the mdb or excel format. It can be done.
0
mkdev2009Author Commented:
Hi, Could you share how to make it in C# ? by saving the it to mdb format. Thanks in advance.
0
srinivasraorajulalpudiCommented:
I need to write the whole code which takes time, i.e need to build the whole windows aplication.
IF you need any assistance in building the application i will assist you. the first way is the best way and it can be completed in a few minutes, if the data base is small.
0
mkdev2009Author Commented:
Yes, i need some sample code on it, as i required to build a system to perform it automatically.  Thanks in advance.
0
srinivasraorajulalpudiCommented:
Hi ,
First try to write the appliation for retrieving the data from the data base, as you know the database name, first we need to retrieve the all the table names, keep them in the string array and then take the names of the each and every tabel and try to retrieve the entrie data, by the criteriria like select * from emp, when we get the data set we need to read the whole data set and need to write the data to the new table or existing table of the mdb file. working on to write the sample code for this requirement. if completed will be posting it.


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.