Tool Required to Convert

[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.

 

[Guest]

How many fields and what are the names that has this data?
Is it something like this ---
ID E-mail1 E-mail2 MyDate
MyTime TypeTime
xyz (e-mail address removed) (e-mail address removed) 05/12/2006 18:25:43 Local

 

[subha]

its something like

First Name1 Last Name E-mail1
--->E-mail2 Date Time TypeTime
First Name2 Last Name E-mail1
--->E-mail2 Date Time TypeTime


Above this has some unwanted space and symbol like ---> and it has to
be in one line
Output should be:

Name1 E-Mail1 Date Time TypeTime
Name2 E-Mail1 Date Time TypeTime

Data Altogether has some 1000+data