csv问题 [英] csv issue

问题描述

我已将（使用简单的ssis）小表的内容导出到.csv文件，我想在excel中编辑此数据，然后通过删除特定的rec来插回到同一个表中ID（pk）。  

正如我们所知，excel将平面文件的日期格式更改为某个数字，我想避免这种更改并希望保持此值相同因为我有兴趣更改其他列值并希望保持日期列值不变。

我知道我可以在记事本或其他工具中执行此操作，但excel非常适合我。  有没有办法解决这个问题。

我正在使用SQLServer 2016和VS 2015

---

Neil

解决方案

你可以使用SSIS

https://kundandblog.wordpress.com/2017/02 / 11 /如何可以移除重复的-记录-在-SQL服务器功能于SSIS /

I have exported (using simple ssis) the content of a small table to .csv file and I want to edit this data in excel before I insert back to the same table by deleting that particular rec on the basis of ID (pk).  

As we know excel changes the format of date of the flat files to some number, I wan to avoid this change and want to keep this value same as is, as I am interested in changing other columns values and want to keep the date column value as is.

I know I can do this in notepad or other tools but excel suits me.  Is there any way around to fix this.

I am using SQLServer 2016 and VS 2015

---

Neil

解决方案

you can use SSIS

https://kundandblog.wordpress.com/2017/02/11/how-to-remove-duplicate-records-in-sql-server-in-ssis/

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