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

How to split data.

P: 93
Hi, I have imported an excel document in access. One of the fileds have data which i need to split into three. Example title forename surname is in one column. I need to split this into 3 columns. Can somebody help. I was thing of doing this in a query but i don't know where to start.
Aug 20 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,532
In order to help, we need to see some examples of the data in this single column, and we need to know if there are always these three components and in the same order.

Linq ;0)>
Aug 20 '08 #2

Expert Mod 15k+
P: 31,661

Try to explain the "Rules" of what goes where as precisely as you can.
Aug 20 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.