How do I combine data from two fields on the same database

I

Irma

I had just downloaded a database. However, it is comma delimited and I need
two fields to come in as one. Access does not allow me to combine the 2
fields while I download. Can anyone help please. Thanks.

Irma

PS I am a new Access 2003 user.
 
K

Klatuu

Use an update query on the table after it is imported to combine the two
fields into the field you want it to be. If you don't want that field to be
there, open the table in design mode and delete it. This is would only be a
good idea for a one time shot. If this is an ongoing activity, I would
suggest an intermediate table to import into, then an append query that
combines the two fields into the production table.
 
I

Irma

Dear Klatuu:

Thank you for the quick response. I will try and do as suggested. Yes this
is a one time situation and your suggestion is fine. Thanks again.
 

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

VBA word change keys 0
Copy previous record into form field 0
How do I clear a form? 0
How do I set focus (and select text) on a text box on a modeless userform? 0
How to compare and combine information from 2 different excelworksheets (VLOOKUP ? Pivot Table ?) 1
Combine two databases into one 4
importing data 0
VBA Linking to a Sharepoint List with a Multivalued field 0

Top