You need a tool (SQL Server Management Studio comes with SQL Server 2005 installation) to get this done easily with many options
If you have MS SQL Server 2005, you can connect to your Express server instance to attach your database created in MS SQL Server 2005 Express and detach it. From the SQL SERVER 2005, attach the database file you detach in Express version.
For Access 2003, you can use the Management Studio to Export to Access.
You can use the trial version to get this tool. I know there is a free version SQL Server Management Studio Express, but I cannot put on my machine to play. Besides it has limited function I need. You can try it if you don't have full sql server 2005 versionon your machine.
Hope this helps.
No comments:
Post a Comment