将数据从MS-Acess 2000导入到SQL Server [英] Import Data from MS-Acess 2000 to Sql Server

问题描述

如何从Ms-Access导入数据到sql server 2003并使用Visual Basic Net 2005上的表单更新sql server上的表.

How to import data form Ms-Access to sql server 2003 and update table on sql server using form at visual basic net 2005

推荐答案

升级数据库，您可以查看此 [

If you are looking at upgrading the database, you can have a look at this[^] useful support article.

请注意，Microsoft会帮助您从SQL Server中创建表作为创建的数据类型进行访问可能是错误的.如果您的列中有数字，但需要保留字符，则该列可能会被创建为浮点数，因为MS正在获取数据样本来做出决定.

Be careful of Microsoft helping in creating tables in SQL Server from Access as the created data types can be wrong. If you have a column that has numbers in it but it needs to hold characters the column may be created as float because MS is taking a sample of the data to make the decision.

这篇关于将数据从MS-Acess 2000导入到SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！