djredden73
New Member
- Joined
- Aug 10, 2012
- Messages
- 29
So I have a large dataset with very minimal columns.
Something like this:
<TBODY>
</TBODY>
I would like to have that turn into:
<TBODY>
</TBODY>
I have almost 8,000,000 rows of data, so I know this is going to triple my records but wanted to know if it can be done in VB in Access?
Something like this:
Primary_KEY | ITEM1 | ITEM2 | ITEM3 | STATUS |
123456ABC | FOOD | DRINK | SILVERWARE | PAID |
<TBODY>
</TBODY>
I would like to have that turn into:
Primary_KEY | ITEMS | STATUS |
123456ABC | FOOD | PAID |
123456ABC | DRINK | PAID |
123456ABC | SILVERWARE |
<TBODY>
</TBODY>
I have almost 8,000,000 rows of data, so I know this is going to triple my records but wanted to know if it can be done in VB in Access?