By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,057 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Tool required to Convert

P: n/a
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:
---> 05/12/2006 18:25:43 Local
Output should be:
xyz 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,

May 23 '06 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Just insert some money. Well, scratch that, a fair amount of money,
and better instructions.

You should look into something like SPLIT, and the basic text
processing functions, like TRIM. Once you have the data into separate
columns/parallel arrays, you can just dump them into Access via code.

May 23 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.