使用HeidiSQL匯入Excel資料

<p style="box-sizing: border-box; margin: 0px 0px 26px; font-size: 18px; line-height: 1.7; color: rgb(48, 50, 51); font-family: Lato, "PingFang TC", "Helvetica Neue", Helvetica, 微軟正黑體, 新細明體, Arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;">按照這操作要留意的就是編碼

<p style="box-sizing: border-box; margin: 0px 0px 26px; font-size: 18px; line-height: 1.7; color: rgb(48, 50, 51); font-family: Lato, "PingFang TC", "Helvetica Neue", Helvetica, 微軟正黑體, 新細明體, Arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;">一開始沒有選擇到導致匯入都是錯誤都是亂碼

<p style="box-sizing: border-box; margin: 0px 0px 26px; font-size: 18px; line-height: 1.7; color: rgb(48, 50, 51); font-family: Lato, "PingFang TC", "Helvetica Neue", Helvetica, 微軟正黑體, 新細明體, Arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;">改成utf8後就可以正常匯入

<p style="box-sizing: border-box; margin: 0px 0px 26px; font-size: 18px; line-height: 1.7; color: rgb(48, 50, 51); font-family: Lato, "PingFang TC", "Helvetica Neue", Helvetica, 微軟正黑體, 新細明體, Arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;">自己寫的時候少編了一個欄位後索性就把資料改成三個欄位匯入

<p style="box-sizing: border-box; margin: 0px 0px 26px; font-size: 18px; line-height: 1.7; color: rgb(48, 50, 51); font-family: Lato, "PingFang TC", "Helvetica Neue", Helvetica, 微軟正黑體, 新細明體, Arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;">以下原本的作者教學文

<p style="box-sizing: border-box; margin: 0px 0px 26px; font-size: 18px; line-height: 1.7; color: rgb(48, 50, 51); font-family: Lato, "PingFang TC", "Helvetica Neue", Helvetica, 微軟正黑體, 新細明體, Arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;">首先要建一個空的資料表如下： 一個鄉鎮(Village)的資料表，裡面有四個欄位，其中CityId是對應到之前City資料表的id欄位，City欄位可以不需要，不過還是留下來，是給人看的不是程式要用的。

<p style="box-sizing: border-box; margin: 0px 0px 26px; font-size: 18px; line-height: 1.7; color: rgb(48, 50, 51); font-family: Lato, "PingFang TC", "Helvetica Neue", Helvetica, 微軟正黑體, 新細明體, Arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;">然後HeidiSQL只能匯入csv格式的Excel檔案， 所以要先把檔案轉成csv檔案， 而csv檔案只能有一個標籤， 所以要先將標籤匯出， 在Excel檔案下方的標籤按右鍵，選擇移動或複製

<p style="box-sizing: border-box; margin: 0px 0px 26px; font-size: 18px; line-height: 1.7; color: rgb(48, 50, 51); font-family: Lato, "PingFang TC", "Helvetica Neue", Helvetica, 微軟正黑體, 新細明體, Arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;">然後勾選新作業簿，並選擇新的檔案

<p style="box-sizing: border-box; margin: 0px 0px 26px; font-size: 18px; line-height: 1.7; color: rgb(48, 50, 51); font-family: Lato, "PingFang TC", "Helvetica Neue", Helvetica, 微軟正黑體, 新細明體, Arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;">之後存成csv檔案，記得檔案類型要選擇csv檔案

<p style="box-sizing: border-box; margin: 0px 0px 26px; font-size: 18px; line-height: 1.7; color: rgb(48, 50, 51); font-family: Lato, "PingFang TC", "Helvetica Neue", Helvetica, 微軟正黑體, 新細明體, Arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;">接下來到HeidiSQL選擇 工具 -> 匯入CSV文件

<p style="box-sizing: border-box; margin: 0px 0px 26px; font-size: 18px; line-height: 1.7; color: rgb(48, 50, 51); font-family: Lato, "PingFang TC", "Helvetica Neue", Helvetica, 微軟正黑體, 新細明體, Arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;">這下來這張圖就是重點了，基本上參考這張圖去操作就可以了 1.瀏覽選擇檔案 2.下方的方式要選 服務器格式化數據(才能改編碼) 3.Excel一般是用big5編碼的，上方的編碼就選big5吧 4.忽略前1行代表那一行是標題列，不要匯入 5.右邊用 , 做分隔(csv是用逗號做分隔的) 6.確認資料庫跟資料表是否正確 7.選擇匯入的欄位，我是用同樣欄位名稱跟順序

<p style="box-sizing: border-box; margin: 0px 0px 26px; font-size: 18px; line-height: 1.7; color: rgb(48, 50, 51); font-family: Lato, "PingFang TC", "Helvetica Neue", Helvetica, 微軟正黑體, 新細明體, Arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;">這樣就大功告成了！

王瘇子C# 學習倉庫

C#初學者資料來源於網路給自己做備忘用