[問題] 大量excel資料轉access
(若是和其他不同軟體互動之問題 請記得一併填寫)
軟體:access, excel
版本:2013
大概有快1000個excel檔案，裡面有40幾萬筆的data
每個檔欄位都不太一樣，但每個欄位都要
例如a檔案有10欄，b檔案又多了a檔5欄，總共就要統整匯進15欄
要怎麼有效率的匯進access
研究到快瘋了
--
Sent from my Android
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 42.71.41.133
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1412045365.A.5AD.html
※ 編輯: a51029333 (42.71.41.133), 09/30/2014 10:51:13
※ 編輯: a51029333 (42.71.41.133), 09/30/2014 11:04:24
→
09/30 13:55, , 1F
09/30 13:55, 1F
→
09/30 14:26, , 2F
09/30 14:26, 2F
→
09/30 14:30, , 3F
09/30 14:30, 3F
→
09/30 14:32, , 4F
09/30 14:32, 4F
→
09/30 17:16, , 5F
09/30 17:16, 5F
→
09/30 17:16, , 6F
09/30 17:16, 6F
→
09/30 17:19, , 7F
09/30 17:19, 7F
→
09/30 17:19, , 8F
09/30 17:19, 8F
→
09/30 17:26, , 9F
09/30 17:26, 9F
→
10/01 00:53, , 10F
10/01 00:53, 10F
→
10/01 00:54, , 11F
10/01 00:54, 11F
→
10/01 00:57, , 12F
10/01 00:57, 12F
→
10/01 12:25, , 13F
10/01 12:25, 13F
→
10/01 12:26, , 14F
10/01 12:26, 14F
→
10/01 12:30, , 15F
10/01 12:30, 15F
→
10/01 12:59, , 16F
10/01 12:59, 16F