How can I convert an EXCEL report into a one Record for ACCESS imp

[Mike M]

How can I set create a VBA program that can arrange a multi-row EXCEL 2007
report by consolidating the lines into one record to import it into ACCESS
2007?

Example: How can I convert all of the information below into one record?

Location Title
DATE
Prev Current Used Cost Sold Purchased
Liquor 14407.60 14767.66 819.71 $535.32 731.00 $731.30
Wine 21399.49 21989.17 931.93 $404.89 1211.06$441.72
Beer 1417 1268 341 $297.78 333 $163.60

 

[Ken Snell MVP]

Define what the record needs to look like in ACCESS, from these EXCEL data.
Note, though, that a database needs to store data relationally, not the same
way as you store data in EXCEL.