Fname, Lname, Mname fields vs. Full Name field

bogglebeats

Registered User.
Local time
Today, 10:01
Joined
Dec 19, 2002
Messages
53
i need to import lots of data into access from text delimited files. Many of the source dbs that i am importing from have one 'contact' field for the name, which combines first, last, and middle. in my access db i have 3 separate fields for this because if i need to look up alphabetically i can use the lname field. is there any way to designate the 'contanct' field (which combines all 3) from the source to the 3 fields in my db without separating it individually? thanks.

ameen
 
Not really sure what you mean by "designate", but from the sounds of what you're trying to achieve, I'd say no.

You need to separate out the name parts and assign them to the 3 fields if you want to work with them separately.
 

Users who are viewing this thread

Back
Top Bottom