Fname, Lname, Mname fields vs. Full Name field

[bogglebeats]

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

 

[dcx693]

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.