How to transfer MS Access into SQL server?
I am new to SQL server. Is there any one can tell me how to transfer the Tables, Forms, Querys, reports and Macros to SQL? (Using DTS ?)
I am new to SQL server. Is there any one can tell me how to transfer the Tables, Forms, Querys, reports and Macros to SQL? (Using DTS ?)
Comments
Search the Access help file for "Upsizing Wizard".
You could use SSIS (built into sql server 2005) or DTS (sql server 2000) (also known as integration services)
You could use a Linked server (inside of sql you can create a link to your ms access database) then do an INSERT INTO [sqlserver.table] FROM [msaccess.table] command to copy your tables from access to SQL directly.
http://www.databasejournal.com/features/mssql/arti...
OR You could use the Access upsizing wizard:
http://support.microsoft.com/default.aspx?scid=KB;...
i think those are the best 3 options.
In EXCEL, export (keep AS) the information to a CSV (Comma Separated fee) document, it truly is a textual content document it truly is formatted by a comma frequently, or different delimeters alongside with a quote " or each so often an area or tab. Then IMPORT the information into your MySQL or *sq. database through phpMyadmin or similar software.