You can automatically convert the Access database into SQL script writing tools.
Coosel2.0 Createsql v1.05
The file contains two versions of ASP and EXE
The ASP version does not support direct import into SQLServer, only support scripting
EXE version can be imported directly into SQLServer
Features:
Generate the promotion SQL script, save to * .sql file, transfer to execution in the SQL2000 query analyzer
Generate promotion ASP scripts so you can use this script and the corresponding MDB database to server online promotion
Execute Access data directly into the SQL2000 server (table structure and data)
http://blog.fz0132.com/trackback.asp?tbid=281
