imported Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I imported a spreadsheet frim excel into Access. The spreadsheet had a very large list of names. The full name was in one field. Obviously when the data was imported to access, each full name went into one field. . Is therre an easy way to separate first and last name from one field into two separate fields. in my access database.
 
How consistent are the names. Are there commas in some and not others?
Do they all have or not have middle names? Are they all first middle last
order?

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


Steve Blostin said:
Hi,
I imported a spreadsheet frim excel into Access. The spreadsheet had a
Click to expand...
very large list of names. The full name was in one field. Obviously when
the data was imported to access, each full name went into one field. . Is
therre an easy way to separate first and last name from one field into two
separate fields. in my access database.
 
If it is just first name and last name you can use the
following code but remember there are the exception like
John Van Dunn. Personnaly I would do this before I imported

strName = "Mr. First LastWordRightHere"
? right(strName, len(strName) - instrrev(strName," "))
LastWordRightHere

? left(strName, instrrev(strName, " ")-1)
Mr. First

Jim
-----Original Message-----
Hi,
I imported a spreadsheet frim excel into Access. The
Click to expand...
spreadsheet had a very large list of names. The full name
was in one field. Obviously when the data was imported to
access, each full name went into one field. . Is therre
an easy way to separate first and last name from one field
into two separate fields. in my access database.
 
Back
Top