import Access .mdb data into sql server 2008 with encode data correctly

Question

q

Answer 1

hi

i have to import access .mdb data into sql server 2008.

i do it with "bulkcopy" ,all data import into sql database but unfortunately my data damaged.

my data in access db is true (in table i have Persian and Arabic information) but in sql all data format change and show me like as "ÊÝÇæÊ ..". 

how can i solve this problem???

please help me....

Answer 2

Hi,

1)We can use a application called "Microsoft SQL Server Migration Assistant for Access". This you can download from

http://www.microsoft.com/en-us/download/details.aspx?id=28763

This will help to migrate  structure, primary keys, indexes , data to SQL server

note : You may need nvarchar type column to store Arabic information. So before bulk copy make sure your corresponding columns are nvarchar type.

or

2) by

1. Open SSMS.
2. Create a new database.
3. Right-click the new database in the Object Explorer.
4. Select Tasks | Import Data... from the context menu.
5. Change the data source to Microsoft Access.
6. Browse for the file name.

But by this way primary key and indexes may not be copied

Answer 3

This one may help.

http://www.fmsinc.com/MicrosoftAccess/SQLServerUpsizing/importing/Import_Access_DB.asp

 

 

 

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

Answer 4

Hello,

Please, could you explain your problem and what you want to do in a clearer way ?

I am sorry but "q" only in the text of your original is not clear.

Please, could you tell us which is the exact version of your Access ( which year ) and the full version of your SQL Server 2008 ( 10 or 10.5 , the last one known as 2008 R2 ) ?

Please, could you tell whether this thread is the same as ?

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/31d5e0c1-3383-41e3-b405-df65ae2cae89/#31d5e0c1-3383-41e3-b405-df65ae2cae89

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 5

Hello,

Thread similar to

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/c30e1bc7-03cc-4b1b-adca-2e9ace858d91/#c30e1bc7-03cc-4b1b-adca-2e9ace858d91

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/31d5e0c1-3383-41e3-b405-df65ae2cae89/#31d5e0c1-3383-41e3-b405-df65ae2cae89

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.