Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Conversion from sql server to ms access?

Author  Topic 

rammohan
Posting Yak Master

212 Posts

Posted - 2008-08-29 : 06:09:32
Dear All,
I Am having sql server 2005 as back for my application. i had db called Test1. now our management insisted me to change back end from this to MS Access. so how i can create the same copy i mean is there any tool or command to copy the structure and data directly from sql server to ms access 2007

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

dexter.knudson
Constraint Violating Yak Guru

260 Posts

Posted - 2008-08-29 : 06:26:28
Right-mouse click on the database in SQL Server & select Tasks->Export data. Then follow the wizard & select MS_Access as your destination. Also read http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50564 if you'd like to script it.
Go to Top of Page
   

- Advertisement -