Re-format inherited EXCEL data from 1 field to 3 fields in ACCESS

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

Guest

The community group I am involved with wants to convert an EXCEL worksheet
into a database that could be used as a mailing list. The EXCEL worksheet
contains 10,000+ addresses that are in the format: 1015 W Armitage (one
field). In order to sort the addresses in ACCESS, I need to convert the one
field EXCEL address into three fields in ACCESS. For example, 1015 W
Armitage, as shown in EXCEL, needs to be converted to the following ACCESS
format:

field 1: 1015
field 2: W
Field 3: Armitage

Is there a way to delete the "W Armitage" and leave the 1015? That would
create field 1. Then I could manually enter "W" for field 2, and use an
update query to add "Armitage" for field 3.

The same situation exists for names. For example, EXCEL has one field for
the name: Smith Mary. I will need to convert the EXCEL one field name to two
fields in ACCESS as follows:
field 1 : Smith
field 2: Mary

Thank you.

PS
I also posted this question in the General Questions section.
 
You have shown us three pieces of information but I am not sure whether
these are in separate rows or columns in Excel. Also, are all 10,000
addresses spaced/formatted exactly the same? Is there any consistent pattern
with the addresses?
 
Back
Top