If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Re-format inherited EXCEL data from 1 field to 3 fields in ACCESS
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. -- Doug -- Doug |
#2
|
|||
|
|||
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? -- Duane Hookom MS Access MVP -- "Doug" wrote in message ... 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. -- Doug -- Doug |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
macro to change chart on excel data field | [email protected] | Charts and Charting | 3 | June 11th, 2004 05:16 PM |
Field code to pick up Excel sheet | Lyndie | Mailmerge | 1 | June 2nd, 2004 11:57 AM |
Pivot Table - Format of Date Field | Michelle | Worksheet Functions | 1 | February 3rd, 2004 07:56 PM |
Pivot Table - Format of Date Field | Peo Sjoblom | Worksheet Functions | 0 | February 3rd, 2004 07:20 PM |