Separating data in one field

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

Guest

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
 
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.
 
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. ;-)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help, i am in panic.....7 days of tutorials and experiments...zip 20
Need VLOOKUP to Work Two Ways 0
Address Field 1
Export Contacts to excel. 2
Multi-word string from one field to two fields 2
Simple Search Form in Access 2007 5
Separating data in a field 2
Line Breaks in cells - Mac OS X Leopard 1

Back
Top