CODEWITHSUNDEEP
sql-server-2008ms-access
MohammedT
MohammedT

Reputation: 517

Data transfer From access to MSSQL server

I got a database in my central MSSQL server and I got an access version with new data on my desktop. Will I be able to transfer the new data into the central MSSQL server database from the access database?

Upvotes: 0

Views: 111

Answers (4)

Bridge
Bridge

Reputation: 30711

MS Access has an upsizing wizard to move data from an Access project to an existing SQL Server database, or create a new one.

I've had to use it before when using Access as a staging platform when using from some anarchic databases up to SQL Server.

There's a guide on how to use it here:

http://office.microsoft.com/en-gb/access-help/use-the-upsizing-wizard-HP005273009.aspx

Upvotes: 0

Christian Phillips
Christian Phillips

Reputation: 18769

You can use Data Import from SSMS.

  1. Right click on DB
  2. select Tasks
  3. Import data..
  4. Select your Access DB as source
  5. Set the mappings etc from your source to destination

You can save this as an SSIS package to either re-run at a later date or to develop in BIDS for a more advanced import toolset.

Upvotes: 3

veljasije
veljasije

Reputation: 7092

You can use one powerful tool for Data Export/Import and that is SQL Server integration Services or SSIS. There you can, not just move data, but do some simple or complex data manipulation, like conversion, mapping, lookup and other...

SSIS are SQL service which can be installed from installation media, and it will be installed only once, because, they are independent of instance, actually belong to shared components.

Beside noted, they are capable of scheduling package execution, so you can do it more times, without any additional work. They are usually used in ETL systems.

They offer rich GUI with many graphical components, so your administration and creation are very easy.

Upvotes: 0

Rikalous
Rikalous

Reputation: 4574

You can link your SQL Server tables into your Access database - use the External Data menu. Then you can write standard Access append queries to move data between them.

Upvotes: 2

Related Questions