import Access .mdb data into sql server 2008 with encode data correctly
-
Saturday, November 17, 2012 7:58 AMq
All Replies
-
Saturday, November 17, 2012 8:05 AM
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....
- Merged by Iric WenModerator Tuesday, November 20, 2012 8:39 AM duplicated
-
Saturday, November 17, 2012 9:10 AM
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
- Open SSMS.
- Create a new database.
- Right-click the new database in the Object Explorer.
- Select Tasks | Import Data... from the context menu.
- Change the data source to Microsoft Access.
- Browse for the file name.
But by this way primary key and indexes may not be copied
- Edited by Johnson T A Saturday, November 17, 2012 9:22 AM
- Proposed As Answer by Papy NormandModerator Sunday, November 18, 2012 1:11 PM
- Marked As Answer by Iric WenModerator Monday, November 26, 2012 3:05 AM
-
Saturday, November 17, 2012 2:18 PM
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.- Proposed As Answer by Papy NormandModerator Sunday, November 18, 2012 1:00 PM
-
Sunday, November 18, 2012 1:04 PMModerator
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 ?
Have a nice day
Mark Post as helpful if it provides any help.Otherwise,leave it as it is.
- Edited by Papy NormandModerator Sunday, November 18, 2012 1:07 PM Question about another thread
-
Sunday, November 18, 2012 1:15 PMModerator
Hello,
Thread similar to
Have a nice day
Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

