Separating data in one field

S

Shanice

I have an excel file that has a field with city, state zip. How can I
separate them into individual fields in Access?

Thank you
 
R

Rick B

Do a search. Asked and answered very often.

In short, you can't always do it reliably. You basically use an update
query to find the comma and the space in the field and parse out the parts.
 
C

CJ

Hi Shanice

A much easier method is to break the data into different columns while it is
still in Excel.

In Excel use the "Text to Columns" function which is found in the "Data"
menu. It will separate the data for you and then you can import it into
Access without having to use any queries.

Hope that helps. ;-)
 
Top