creat new table from text file records.
1, creat text fie like this.
1,"dino"
2,"sino"
3,"fino"
4,"ahno"
save data.txt
and go to access.
file>go to external data>import>selece data txt file>click import>
delimited>next
comma>next
new or exiting table>next
next next. finished.