Ok, I don’t really like doing this, but I have a question and can’t find the answer on the net anyplace.
I’m in the process of converting a bunch of Excel spreadsheets into database’s in Access. Somone sent me one yesterday, and they have one colum for both first name and last name. Like this:
Now my question is, I seem to remember coming across a referance someplace that hinted at a way to separate this into two fields in Access using an SQL query. I can put two field together with a Union Statement, but don’t know how to separate them.
Has anyone done this?..Or know of a great resource on the net that I can use?..While I know the company I work for has all the license agreements, getting any help from Microsoft for this level of support is difficult…(I’ve tried before. They are great for simple questions, but more complex stuff is beyond what you can find out).
Any help on this would be appriciated…if it’s too much of a pain to post the whole thing here, e-mail me and I’ll work out another way. Thanks all…