SQL Server Database Convert To MS Access

Question

0.00/5 (No votes)

See more:

ASP.NET

SQL

SQL-Server-2012

Can anyone help me ........???

Posted 25-Jan-15 2:35am

Member 11262250

Add a Solution

Comments

Deepu S Nair 25-Jan-15 8:37am

Please Improve your question.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Answer 1 · 2015-01-25T02:47:00

Solution 1

I doubt. You can try to export tables from SQL Server to an MS Access file (http://help.dugeo.com/m/faq/l/176948-exporting-sql-database-to-access[^]), but you never be able to "convert" - they are on different level...

Posted 25-Jan-15 2:47am

Zoltán Zörgő

DamithSL · Answer 2 · 2015-01-25T02:51:00

Solution 2

You can try SQL server import export wizard but it may have limitations. try below steps and check whether it match with your requirements or not.

1. Log into sql server management studio
2. right click: task > export data
3. select your sql server database
4. select destination as microsoft access, browse and give destination access file
5. specify which tables/views
6. run it

Posted 25-Jan-15 2:51am

DamithSL

Updated 25-Jan-15 3:23am

v2

Comments

Kornfeld Eliyahu Peter 25-Jan-15 9:08am

It will transfer the data from SQL to Access, but in a sense it will not convert the SQL database, as SQL database can be much more than its data...

Member 11262250 25-Jan-15 9:46am

but what is meaning of file name at destination ?

DamithSL 25-Jan-15 10:09am

destination filename means which access database file you want to export sql server database tables/views