从sql复制Excel的问题 [英] Problem to Copy Excel from Sql

问题描述

我已将sql数据复制到Excel.已成功复制.但是字段表名"的问题之一是sql varchar格式.它包含

I was copied my sql datas to Excel. It is copied Successfully. But the Problem one of the Field ''Tablename'' is in sql varchar format. It contains

Tablename
1
2
1-1
1-2
1-3
3-1
2-1

当我复制到excel时，将显示excel文件，如下所示

When i copied to excel the excel file is display like following

Tablename
1
2
1-Jan
2-Jan
3-Jan
1-March
1-Feb

如何解决此问题，请帮助我

how to solve this problems pls help me

推荐答案

如我所见，由于您只是复制到excel而不会导出，因此最好将列格式设置为文字"在excel中.我认为常规"格式在这里可能无法使用.

As I see, since you are just copying to excel not export, so you d better to set the column format as "Text" in excel. I think the "General" format may not work here.

在excel中将列格式更改为常规"或文本".

Change column format to "General" or "Text" in excel.

这篇关于从sql复制Excel的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！