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 ?)

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.

Sign In or Register to comment.