熟悉SQL SERVER 2000的数据库管理员都知道,其DTS可以进行数据的导入导出,其实,我们也可以使用Transact-SQL语句进行导入导出操作。在Transact-SQL语句中,我们主要使用OpenDataSource函数、OPENROWSET 函数,关于函数的详细说明,请参考SQL联机帮助。利用下述方法,可以十分容易地实现SQL SERVER、ACCESS、EXCEL数据转换,详细说明如下:
try to use Import/Export Data wizard which in the Microsoft SQL Server group, but there are some issues you have to consider, see
Migrating Your Access Database to MS SQL Server 7.0
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql7res/part11/sqc18.asp
Data Structure Differences between Access and SQL Server
http://www.databasejournal.com/features/mssql/article.php/1490561
Microsoft Access Upsizing Tools 97
http://www.microsoft.com/AccessDev/ProdInfo/AUT97dat.htm