Lname, Fname fields VS. Full Name field.

[dulla]

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

 

[scriverb]

Imort the data as is and after and then run an Append query which parses the single field Contacts into the three fields of your ACCESS table. Each of these files may be a little different in their format for their names. So, the Append query will have to be adjusted for each.

I can assist you with the parsing if you tell me the rules for the individual field. i.e. LastName, FirstName M or without the comma, deliminted with ;, etc.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[dulla]

oops. i looked at the original source and it is separated for me. however i do have a similar problem with 2 address fields. i would like to combine two fields, adress1 and adress2 before i import it. i have imported into access in a new table, i would like to append it there then join the tables that i need to join. how do i append the fields of address1 and address2 as a new field Address: address1, address2? thanks.

ameen

 

[scriverb]

Here is an update query SQL that can be used to cancatenate your address fields into one:

UPDATE <YourTableName> SET [<YourTablename>].Address = [<YourTableName>]![Address1] & &quot; &quot; & [<YourTableName>]![Address2];

Just replace your tablename in the red areas.




Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???