importing from another db (1 Viewer)

[jarheadjim]

i need to import a list of names from another database. They are stored as 3 fields now: [last], [first] and [int], I want them all in one field that should show "last, first int". How do I go about doing that?

 

[Krysti]

Question? Why do you want them all in one field? Just asking because you can use [last] & "," & [first] & " " & [int] if you want to display it that way in a form or a report. It's usually best to keep the fields separate in the underlying table.

If you do want it that way in the table though, I would export it to Excel and use the Concatenate function. This will allow you to put them all in one cell the way you want. Then you have to take that column and do a "paste special" and past the values to another column. Delete all the other columns and import the Excel file into Access again.

Let me know if you need more information than this.

Good luck!

Krysti

 

[jarheadjim]

thanks!

my problem was that i wasn't using quotations around the , or blanks. what i wound up with was [last]+", "+[first]+" " +[int] and then just cut and paste as needed. I appreciate the help.