SQL Server 2012 DQS xu?t kh?u sang 64-bit .xls t?p tin Excel th?t b?i v?i l?i

D?ch tiu ? D?ch tiu ?
ID c?a bi: 2712972 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

Tri?u ch?ng

Khi s? d?ng SQL Server 2012 b?n ghi d?ch v? ch?t l?ng d? li?u, trn m?t my tnh m Microsoft Excel 64-bit ?c ci ?t chuyn bi?t, h?y xem xt k?ch b?n sau y
1. B?n s? d?ng d? li?u ch?t l?ng khch hng ? ch?y m?t d? n Cleansing ho?c k?t h?p d? li?u

2. B?n hon t?t cc b?c c?n thi?t ? ?t ?c xu?t kh?u trang cu?i cng c?a d? n ch?t l?ng d? li?u.

3. B?n c? g?ng ? xu?t k?t qu? lm s?ch, ?n ch lo?i "Excel File"
B?n nh?p vo nt ch?n m?t duy?t ? ch? ?nh m?t t?p tin Excel hi?n xu?t chuy?n.
B?n ch? ?nh cc lo?i t?p tin xu?t kh?u nh "s? lm vi?c Excel 97-2003 (*.xls)" v tr? ?n m?t t?p tin v?i ph?n m? r?ng .xls.
B?n nh?p vo nt ch?n m?t m? ? l?a ch?n t?p tin ch.

4. B?n nh?p vo nt ch?n m?t xu?t kh?u ? ch?y cc hnh ?ng xu?t kh?u.

M?t l?i xu?t hi?n:
"T?p tin t?i v? khng, ki?m tra r?ng t?p tin ch xu?t kh?u cha t?n t?i."

Nguyn nhn

Trong tr?ng h?p ny xu?t kh?u sang cc lo?i t?p tin Excel 2003-2007 *.xls khng, l m?t l?i.

DQS s? c th? ? xu?t kh?u sang *.xls khi Microsoft Excel 64-bit ?c ci ?t chuyn bi?t m khng c l?i.

Gi?i php

Thng tin gi b?n ghi d?ch v? cho SQL Server 2012

? gi?i quy?t v?n ? ny, c ?c gi b?n ghi d?ch v? m?i nh?t cho SQL Server 2012. ? bi?t thm chi ti?t, nh?p vo s? bi vi?t sau ? xem bi vi?t trong c s? ki?n th?c Microsoft:
2755533 Lm th? no ? c ?c gi b?n ghi d?ch v? m?i nh?t cho SQL Server 2012

B?n by gi? c th? duy?t v xc ?nh xu?t kh?u t?p tin c ph?n m? r?ng *.xls b?t ln v ch?y m khng c l?i, xu?t kh?u, hnh ?ng khi Excel 64-bit ?c ci ?t chuyn bi?t trn my tnh.

Thng tin thm

Khi s? d?ng 64-bit Microsoft Excel 2007 ho?c 2010 trn my tnh ni khch hng ch?t l?ng d? li?u ?c ci ?t chuyn bi?t, b?n c th? xu?t kh?u ch? ? tng h?p v? sau ng?c Excel 2003-2007 *.xls file format, ho?c ch?n m?t i?m ?n lo?i v d? nh SQL Server ho?c CSV (comma delimited t?p vn b?n).

l hnh vi d? ki?n SQL Server 2012 d? li?u ch?t l?ng khch hng khng th? xu?t d? li?u d? n sang d?ng th?c t?p *.xlsx m?i hn khi phin b?n Microsoft Excel ci ?t chuyn bi?t 64-bit. i?u ny l do thi?t k?.

Khi s? d?ng 32-bit Microsoft Excel 2007 ho?c 2010 trn my tnh ni khch hng ch?t l?ng d? li?u ?c ci ?t chuyn bi?t, b?n c th? xu?t kh?u sang *.xlsx *.xls, ho?c ch?n m?t i?m ?n lo?i v d? nh SQL Server ho?c CSV.


Xu?t kh?u t? m?t DQS lm s?ch d? n
http://technet.Microsoft.com/en-US/Library/hh213061 (sql.110) .aspx #Export

Xu?t kh?u t? m?t DQS ph h?p v?i d? n
http://technet.Microsoft.com/en-US/Library/hh270289 (sql.110) .aspx #SurvivorshipandExportStage

? xem cc phin b?n c?a Excel v pht hi?n n?u n l 64-bit ho?c 32-bit.
Trong Excel 2007
Nh?p vo nt ch?n m?t Office tr?n ? pha trn bn tri. Ch?n nt ch?n m?t ty ch?n, s? xem theo trang ti li?u tham kh?o. Xem cc gi?i thi?u v? m?c.

Trong Excel 2010
Nh?p vo tab File trn bng,
Nh?p vo trang tr? gip, v lu ? cc phin b?n trn c?a s? bn ph?i d?i tiu ? v? Microsoft Excel.
S? phin b?n v ki?n trc s? ?c li?t k, ch?ng h?n nh (32-bit) ho?c (64-bit)

Thu?c tnh

ID c?a bi: 2712972 - L?n xem xt sau cng: 16 Thang Mi Mt 2012 - Xem xt l?i: 2.0
p d?ng
  • Microsoft SQL Server 2012 Business Intelligence
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
T? kha:
kbtshoot kbmt KB2712972 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny: 2712972

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com