Sql-server – Migrate a table from MS Access to SQL Server 2012?

sql server

How to migrate a table from MS Access to SQL Server 2012?

Suppose I am inserting data in MS Access, how will it get upgraded in SQL Server 2012 without dropping or recreating a table?

Best Answer

From MS Access:

Select 'Database Tools' from the Ribbon, inside there's the 'SQL Server' option (also called Upsize Wizard). Once in the wizard you can choose between creating a new table on the SQL Server database of your choice or using an existent table (if you choose to use an existent table you are to make sure the field types on your Access database match the ones on your SQL Server one).

In the next steps you must select your SQL Server instance and also which fields you want to upsize along with indexes, table relationships, etc.

Suppose I am inserting data in MS Access, how will it get upgraded in SQL Server 2012 without dropping or recreating a table

I'm not very clear on what you mean here, if what you mean is to have an Access frontend where you collect data and you want it to 'send' this data also to an SQL Server database (which sounds very eclectic, btw) you can use VBA for that.

Heres a discussion on the matter that would do just that: VBA to Append Access data to SQL Server Table

If this is not the case then you'll need to update your question with more info.