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
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:)
