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

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.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


"Mike M" <(E-Mail Removed)> wrote in message
news:3EE10450-DE1A-4E2B-9802-(E-Mail Removed)...
> 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