n********6
发帖数: 1511 | 1 ssis use '' to format the text, and export to excel. Do not find solution on
web. |
j*****n
发帖数: 1781 | 2 你不选择text qualifier 这个不就行了么？ |
n********6
发帖数: 1511 | 3 wizard,default text qualifier (none), source sql native client, destination
excel, data conversion (unicode/latin), get the extra single quote (') in
front of each cell in string(varchar) format.
【在 j*****n 的大作中提到】
: 你不选择text qualifier 这个不就行了么？
|
g***l
发帖数: 18555 | 4 PREVIEW一下看看有没有，不行就用CSV吧，EXCEL的FORMAT有时候比较头痛，64BIT的
IMPORT/EXPORT WIZARD也有问题 |
j*****n
发帖数: 1781 | 5 for only one single quote, it is just for Excel internal use. Unless you
kick the specific cell and then will see it in the top of value line;
otherwise i don't believe you can even see it.
destination
【在 n********6 的大作中提到】
: wizard,default text qualifier (none), source sql native client, destination
: excel, data conversion (unicode/latin), get the extra single quote (') in
: front of each cell in string(varchar) format.
|
n********6
发帖数: 1511 | 6 preview没有.
【在 g***l 的大作中提到】
: PREVIEW一下看看有没有，不行就用CSV吧，EXCEL的FORMAT有时候比较头痛，64BIT的
: IMPORT/EXPORT WIZARD也有问题
|
n********6
发帖数: 1511 | 7 you are right. Only see if I click the specific cell. will double check
tomorrow.
【在 j*****n 的大作中提到】
: for only one single quote, it is just for Excel internal use. Unless you
: kick the specific cell and then will see it in the top of value line;
: otherwise i don't believe you can even see it.
:
: destination
|
B*****g
发帖数: 34098 | 8 Is it a real Excel file or CSV file?
【在 j*****n 的大作中提到】
: for only one single quote, it is just for Excel internal use. Unless you
: kick the specific cell and then will see it in the top of value line;
: otherwise i don't believe you can even see it.
:
: destination
|
n********6
发帖数: 1511 | 9 real excel file because:
1. destination excel
2. file extension: .xls
to generate csv file, destination should be "flat file" and choose csv (
another option txt)
【在 B*****g 的大作中提到】
: Is it a real Excel file or CSV file?
|
n********6
发帖数: 1511 | 10 目前已产生csv文件以规避这个问题。
潜在问题：用comma 分栏，column内就无法用comma。（将就吧。用.不用，)
用其他分栏，直接用excel打开不分栏，而最终用户不会导入到excel内。（不指望教会他们） |
