AC5FF
Registered User.
- Local time
- Today, 17:27
- Joined
- Apr 6, 2004
- Messages
- 552
Probably something simple here but I can't seem to get it figured out.
I've imported a huge text file and have pulled out the relivant data I need to store using a query. The data comes out like:
(date) ... 9/29/2017
(B)...1
(T)...0
(F)...18
(I)...101
(Z)...82
But I need to put this into a table; stored like:
(date)........(B)...(T)...(F)...(I)...(Z)
9/29/2017...1.....0.....18....101...82
Just can't wrap my head around making this happen. Anyone have an idea?
I've imported a huge text file and have pulled out the relivant data I need to store using a query. The data comes out like:
(date) ... 9/29/2017
(B)...1
(T)...0
(F)...18
(I)...101
(Z)...82
But I need to put this into a table; stored like:
(date)........(B)...(T)...(F)...(I)...(Z)
9/29/2017...1.....0.....18....101...82
Just can't wrap my head around making this happen. Anyone have an idea?