有没有办法将Access DB转换为SQL Server? [英] is there a way to convert Access DB to SQL Server ?
问题描述
你好,
我有一个访问数据库表,让我说它是这种形式
第1栏----第2栏----第3栏----第4栏
我想在此表中将数据插入到SQL表中服务器数据库
但SQL Server表有不同的架构
这样的例如
第1栏----第3栏----第5栏----第4栏----第2栏----第6列
有没有办法使用ASP.Net,C#将数据从第一个访问表复制到第二个SQL表?
提前感谢:)
Hello,
I have an access DB table, let me say it's in this form
Column 1 ---- Column 2 ---- Column 3 ---- column 4
and I want to insert data from this table to table at SQL Server DB
but SQL Server table has a different schema
like this for example
Column 1 ---- Column 3 ---- Column 5 ---- column 4 ---- Column 2 ---- Column 6
is there a way to copy data from the first access table to the second SQL table using ASP.Net, C# ?
thanks in advance : )
推荐答案
假设您知道要在第5列插入的值第6列,你要做的就是在插入数据时命名列:这样列的顺序是无关紧要的,SQL会将哪个值放在哪里:
Assuming you know the values you want to insert at Column 5 and Column 6, all you have to do is name the columns when you insert the data: that way the order of the columns is irrelevant, SQL will sort out which value goes where:
INSERT INTO MyTable (column1, column2, column3, ...) VALUES ('C1', 'C2', 'C3', 'C4'...)
如果要将Access数据库转换为SQL Server数据库,请查看此文章
http://support.microsoft.com/kb/237980 [ ^ ]
http://technet.microsoft.com/en-us/library/hh313039.aspx [ ^ ]
http://sqlmag.com/database-administration/15-steps-convert-access-data-sql-server [ ^ ]
if you want convert your Access database to SQL Server database look at this articles
http://support.microsoft.com/kb/237980[^]
http://technet.microsoft.com/en-us/library/hh313039.aspx[^]
http://sqlmag.com/database-administration/15-steps-convert-access-data-sql-server[^]
这篇关于有没有办法将Access DB转换为SQL Server?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!