We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Extract data to mdb format

Medium Priority
465 Views
Last Modified: 2013-12-17
Hi Expert,
  Anyway we can extract the data from db to mdb file format for microsoft access?
Comment
Watch Question

CERTIFIED EXPERT

Commented:
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

Author

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?
CERTIFIED EXPERT

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

Author

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

Author

Commented:
Hi, Could you share how to make it in C# ? by saving the it to mdb format. Thanks in advance.
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.

Author

Commented:
Yes, i need some sample code on it, as i required to build a system to perform it automatically.  Thanks in advance.
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.