将数据库从sql server转换为ms-accss [英] Converting database from sql server to ms-accss

问题描述

大家好，
我有多个表的ms访问数据库.现在我想将此ms-access数据库转换为sql server.
有可能吗?
如果是的话..
您能告诉我解决方案吗?

Hi all,
I have ms access database having multiple tables.now i want convert this ms-access database to sql server.
is it possible?
if yes..
can you please tell me solution

推荐答案

请参考以下主题:
Access-SQL:
将Access数据库转换为SQL Server [将MS Access(* .mdb，*.accdb)迁移到SQL Server 2000/2005或更高版本的数据库 [ ^ ]
将MS访问权限转换为SQL Server [ ^ ]

SQL访问:
Microsoft SQL Server到MS Access的转换 [工具 [ ^ ]

Please refer following threads:
Access-SQL:
convert an Access database to SQL Server[^]
Migrating MS Access (*.mdb,*.accdb) To SQL Server 2000/2005 or higher database[^]
Convert MS Access to SQL Server[^]

SQL-Acess:
Microsoft SQL Server to MS Access conversion[^]

Also Have a look at the SQL Server Migration Assistant tool[^]

使用此CP文章:
将数据从SQL Server导出到MS Access [ ^ ]

其他资源:
http://www.youtube.com/watch?v=yexpN4HYilc [ http://cfpayne.wordpress.com /2006/07/23/how-to-import-microsoft-access-into-sql-server-2005/ [ http://geekswithblogs.net/tewissler/archive/2006/08/15/88077.aspx [^ ]

Hi,

Use this CP article:
Export data from SQL Server to MS Access[^]

Other resources:
http://www.youtube.com/watch?v=yexpN4HYilc[^]

Convert MS Access to SQL Server:
http://cfpayne.wordpress.com/2006/07/23/how-to-import-microsoft-access-into-sql-server-2005/[^]
http://geekswithblogs.net/tewissler/archive/2006/08/15/88077.aspx[^]

这篇关于将数据库从sql server转换为ms-accss的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！