Question macro to manipulate unstructured data like Excel does

Hi all,
I have some tables need to be imported to Access, which is not well structured. For example:

report
4/05/2014
from SQL server
Name ID Add.....
aaa 111
bbb 222


So after imported data, the table needs to process a bit to turn it into a 'Database Table', which is pretty easy to do it in Excel via macro. But I'm not sure how to get it done in Access, please advise, thanks in advance:)

Question macro to manipulate unstructured data like Excel does