Import DataBase from Access to SQL server 2014

Question

Import DataBase from Access to SQL server 2014

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63503 More actions · Answer 1

You should be able to connect to mdb files from SQL Server using Jet 4.0 and then query those, including creating new tables based on the data in the tables you have.

Salwa SSC Enthusiast Points: 128 More actions · Answer 2

I really want to do this, but the (import) process for database is not completing

Salwa SSC Enthusiast Points: 128 More actions · Answer 3

Is there a way other than (import) to include a database of type Access in sql aerver 2014?

pietlinden SSC Guru Points: 63503 More actions · Answer 4

Can you use the upsizing wizard?

Move Access data to a SQL Server database by using the Upsizing Wizard - Microsoft Support

Salwa SSC Enthusiast Points: 128 More actions · Answer 5

Thank you all, the problem has been resolved and the database has been included in the application (ٍَSQL server 2014)

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 6

So what was your final problem and resolution?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Salwa SSC Enthusiast Points: 128 More actions · Answer 7

When doing (upsizing wizard), problems appeared in copy (sql server), so I deleted it and installed it again, and after I tried (import), it worked and the database was included in it

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 8

Salwa wrote:

When doing (upsizing wizard), problems appeared in copy (sql server), so I deleted it and installed it again, and after I tried (import), it worked and the database was included in it

Awesome. Thank you very much for the post.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)