Export Table in MS SQL 2005

ramziabk
ramziabk used Ask the Experts™
on
I have a field in my MS SQL 2005 database used for Arabic comments. If I query the table via SQL, I can see the arabic words how ever if I try to export or copy and paste into Excel, the Arabic words got corrupted!!!!

Any idea?

Note that the Database coailtions caters for Arabic.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Meir RivkinFull stack Software Engineer

Commented:
how do u export the data to excel?
are u using something like:

INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=c:\contact.xls;',

Author

Commented:
Nope.
Just windows copy and paste.
Meir RivkinFull stack Software Engineer

Commented:
u need to change the excel settings to support unicode.
what excel version u have?
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
Excel 2007
Meir RivkinFull stack Software Engineer

Commented:
did u change the excel settings to support arabic (or unicode for that matter)?
Commented:
Try when paste in excel choose paste special >  unicode text or unformatted unicode text

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial