By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,503 Members | 2,730 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,503 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:
xyz x...@something.com
--->x...@something.com 05/12/2006 18:25:43 Local
Output should be:
xyz x...@something.com 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

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.