Tool To Convert in Access

[subha]

Hi ,

Can Someone help me out to Create a tool in Access which Converts
Unaligned data to aligned data in Access.


example of unaligned data:


xyz (e-mail address removed)
--->[email protected] 05/12/2006 18:25:43 Local


Output should be:


xyz (e-mail address removed) 05/12/2006 18:25:43


file consist of lotsa data and which are not in order, please do help
me to get above output in Access.


thanks in advance,
subha

 

[Rick B]

Please stop posting this. ONE post per question in ONE newsgroup is
sufficient.