[求助]如何把这个TXT导入ACCESS
文本文件如下:000001,6226458763125487,女,wang,li,ya ,0909,987123479017837489203748397889283892,MD5A
000002,6226458763125487,女,peng,li ,0909,987123479017837489203748397889283892,YL1A
000003,6226458763125487,男,wang,dong ,0909,987123479017837489203748397889283892,MD5A
000004,6226458763125487,男,chen,jie,bin ,0909,987123479017837489203748397889283892,MD5P
000005,6226458763125487,女,du,li ,0809,987123479017837489203748397889283892,YL1P
000006,6226458763125487,男,sun,xiao,peng ,0809,987123479017837489203748397889283892,MD5A
000007,6226458763125487,男,hao,yan ,0909,987123479017837489203748397889283892,MD3A
000008,6226458763125487,女,wang,jia,luo ,0909,987123479017837489203748397889283892,YL5A
000009,6226458763125487,男,sun,qi,ming ,0709,987123479017837489203748397889283892,MD3B
000010,6226458763125487,女,chen,dong,fen ,1009,987123479017837489203748397889283892,MD9B
.
.
.
大概有一万条。
我在ACCESS中已经建了一个表a,只有字段名没有内容,一共有七个字段,如何把文本文件按字段写入ACCESS表a中?1-6位是字段1,8-23位 是字段2,25-28位是字段3,60-63位是字段4,65-101位是字段5,103-104位是字段6,107-108位是字段7,用MID函数。