Migration of data from MsAccess to MS SQL

Question

I have a data in MS Access which I want to migrate into MS SQL. Data stored is in foreign language not in english. I can read data in Access as I have stored regarding font in C:\Windows\Fonts.

I have migrated Access database into MSSQL by in built functionality of MS SQL, but I can not read(data stored in wierd character) this data directly in MS SQL and in .Net web application also.

Can any one suggest me please?

Have you made sure that your MS SQL uses UTF-8 as its character set? — Erik Karlstrand
– Erik Karlstrand, Commented Jun 15, 2015 at 5:36
What data type is the column in SQL Server - is it NVARCHAR? Please expand on 'can not read'. Do you get an error? wierd characters? — Nick.Mc
– Nick.Mc, Commented Jun 15, 2015 at 6:47
@Nick.McDermaid Column types are nvarchar. and also characters are wierd — Jignesh Gadhia
– Jignesh Gadhia, Commented Jun 15, 2015 at 9:37
I suggest you use the UNICODE function to inspect the first character of the data in the field. It's possible the data uploaded correctly but none of your clients can display it. UNICODE will tell you if the character in the field is indeed the correct unicode character. — Nick.Mc
– Nick.Mc, Commented Jun 15, 2015 at 22:41

ManP · Accepted Answer · 2015-06-15 05:45:08Z

1

Please follow the steps described in official MS support:

You need to use import wizard and test the columns as you go.

answered Jun 15, 2015 at 5:45

ManP

2311 silver badge6 bronze badges

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

Comments

Joscion · Accepted Answer · 2015-06-15 05:52:56Z

0

You could also use the upsizing wizard within the Access database. The instructions are here:

https://support.office.com/en-us/article/Move-Access-data-to-a-SQL-Server-database-by-using-the-Upsizing-Wizard-5d74c0df-c8cd-4867-8d07-e6e759d72924

The wizards do not move everything though:

https://blogs.office.com/2012/02/17/five-common-pitfalls-when-upgrading-access-to-sql-server-2/

Edit:

You could use the wizards to create a new sql server db, that way the encoding & collation is done automatically.

answered Jun 15, 2015 at 5:52

Joscion

696 bronze badges

Collectives™ on Stack Overflow

Migration of data from MsAccess to MS SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related