Archive contains ASP and Exe two versions
ASP version does not support direct import to SQL Server, only script writing is supported
Exe versions can be imported directly to SQL Server
Function:
Generate upsizing SQL script, save as *.sql file, SQL2000 Query Analyzer into execution
Generate a Upsizing ASP script so you can upload it to the server online with the script and the corresponding MDB database
Directly execute Access data import to SQL2000 Server (table structure and data)
V1.03
Version correction bit type problem in which the default value is not converted correctly
The time default value is increased by converting the Times () date () to GETDATE ()
The VBA function for the view is not processed, and the later version launches the T-SQL conversion that supports SQL Server
V1.04
Support input build and login creation
Enable access to import SQL directly
V1.05
Version add direct import SQL Server functionality
Add Import options All table indexes are imported in Unicode encoding, import data is generated, and so on
Fix the default value to handle the perimeter single double quotes, the default value of access is surrounded by no single quotes, and some of the errors are set to null characters as '
is wrong for access, not equivalent to (') in SQL Server, which is automatically corrected by the importer
V1.05 found a lot of forums and the whole station database has been tested and successfully imported
Program generates a upsizing script from the Access2000 MDB database to SQL Server (table structure and data)
Include default, index primary key foreign key view and entire MDB library table
----------------
Source code: Miscrosoft Visual Basic 6.0
Compilation environment: Windows2000 Server 2.00.2195 SP4
If prompted COMDLG32. OCX Version Expired
Use the COMDLG32 provided with the program. OCX Replace WINDOWS\SYSTEM32\COMDLG32. OCX under the
or run Regocx.exe to re-register the Comdlg32.ocx control
Note Backup source file name, Microsoft's File Selection dialog box control
------------------------------------------------------
For more information please pay attention to the Classic Forum database version and Paintblue.net program Publishing area
Programming: V37 paintblue.net (2004-11-20)
All rights reserved: Paintblue.net | Blueidea.com
Whether it is business or free, you are free to use
Download this file
Download this file
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
