How to import Sql server database (*.mdf) in to Ms Access 2007 database(*.accdb) ?
How to import Sql server database (*.mdf) in to Ms Access 2007 database(*.accdb) ?
I have created one databse Production.mdf in sql server 2008 , now how can i import this database
in to Ms Access 2007 using odbc or any other tool ?
I have created one databse Production.mdf in sql server 2008 , now how can i import this database
in to Ms Access 2007 using odbc or any other tool ?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
- why not use the sql server management studio (SSMS) import/export wizard? in SSMS, right click on the database and select "Task" then "Export". then in the option diogbox, choose to export the table structure or with data to Access.
- more in the documentation:
http://msdn.microsoft.com/en-us/library/ms140052.aspx
http://msdn.microsoft.com/en-us/library/ms141209.aspx
- more in the documentation:
http://msdn.microsoft.com/en-us/library/ms140052.aspx
http://msdn.microsoft.com/en-us/library/ms141209.aspx
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
External Data Tab -> Import Group -> More -> ODBC Database
You need to setup your ODBC to connect it into your SQL Server.
Sincerely,
Ed