How to transfer MS Access into SQL server?

Question

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

Answer 1

Search the Access help file for "Upsizing Wizard".

Answer 2

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/article.php/3085211



OR You could use the Access upsizing wizard:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q325017



i think those are the best 3 options.

Answer 3

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.