Splitting an Access Field

L

LisaLu

I have a field in a table created by a co-worker named "Contact" and it
contains the person's first and last name. I want to split it into two
fields - First Name and Last Name. I know there is a way to do this that
will split the field and the data at the same time. I cannot remember how to
do it and the Access Help has been of no use. Can you please help me??
 
V

Van T. Dinh

Check Access VB Help on the following functions that you may be able to use:

Split, Left, Mid, Right, InStr
 
T

Tom Wickerath

In addition to Van's suggestion, there are a couple of other alternatives you
can use. I use the Splitter add-in utility for Access. If you have any kind
of recurring need to split name data, then the $39 investment is well worth
it:

http://www.infoplan.com.au/splitter/

The other alternative is to export your name data to Excel. Then use Data >
Text to Columns... You'll likely want to choose delimited, and specify a
space character as the delimiter. You may end up with some records that need
correcting manually, but you'll likely end up with the same situation by
using the various functions in Access to do the same task. Then, bring the
split name data back into Access. You might want to export the table's
primary key during the initial export to Excel, so that you can later use
this key to join tables for running an update query to update the name data.

Tom
____________________________________

:

I have a field in a table created by a co-worker named "Contact" and it
contains the person's first and last name. I want to split it into two
fields - First Name and Last Name. I know there is a way to do this that
will split the field and the data at the same time. I cannot remember how to
do it and the Access Help has been of no use. Can you please help me??
 
Top