================== 2004 ===================== 1.)Download 1/1/2004~ 11/30/2004 from Payapal ->1-11-ok.cvs 2.)檢查cvs是否有新增field, 要調整access field format 3.)Access->檔案->取得外部資料->匯入->txt file->選1-11-ok.cvs 4.)符號->先勾選(第一列是欄名)->字串辨識符號"->匯入現存table 5.)分類搬移(withdrawn, ebay fee, shopping, shipping) ================== 2003 ===================== 1.)Copy Download-2003-1-ok.csv~Download-2003-12-ok.csv to new folder as 1.csv~12.csv 2.)1~7月 同field, 8,9,10月有新增field, 所以要調整各月field統一format 3.)combine 1~12.csv to 1-12.csv 4.)開新空白access, 匯入1-12.csv, 先勾選(第一列是欄名), 再取消,匯入 5.)更改欄位格式, 搬移(轉帳資料, ebay付款, shipping)