How we import access database(.mdb) into sql server 2008 in C#

Question

I used access database in my project. I want to import full data of my database to sql server 2008. How can I do this?

RBarryYoung · Accepted Answer · 2013-12-14 15:26:34Z

3

Later versions of Access have an Upsizing Wizerd built-in which will assist you in migrating your Access DB to SQL Server. It's usually under the [Database Tools] menu.

answered Dec 14, 2013 at 15:26

RBarryYoung

57k15 gold badges99 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Damith · Accepted Answer · 2013-12-14 15:06:20Z

2

you can use SQL Server Import and Export Wizard, check below link for more information

Importing and Exporting Data by Using the SQL Server Import and Export Wizard

answered Dec 14, 2013 at 15:06

Damith

63.2k13 gold badges106 silver badges154 bronze badges

Comments

bjnr · Accepted Answer · 2013-12-14 23:47:08Z

1

Yes, using the Upsizing Wizard: open Access database, select Tools menu, and then Database Utilities menu. Upsizing utility is not included in default installation of Microsoft Access, so you’ll need to install in order to benefit of it.

What you export is your data, indexes, and defaults. The great thing is that Upgrading Wizard maintains your table relationships and referential integrity after upsizing. Be aware, upsizing operation means only a conversion for you i.e. it won’t take advantage of SQL Server features.

You’ll have some fun converting Access queries to SQL Server views or stored procedures as wizard didn’t make it.

answered Dec 14, 2013 at 23:47

bjnr

3,4371 gold badge24 silver badges36 bronze badges

Collectives™ on Stack Overflow

How we import access database(.mdb) into sql server 2008 in C#

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related