joining/merging two columns into one

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

Guest

Hello,

I am looking to import an Excel spreadsheet into a previously existing Access
database. I have modified the spreadsheet to fit the Access field sequence.
However, the pre-existing Access database has one column for "StreetAddress"
and the Excel spreadsheet has two columns for "street 1" and "street 2".
I want the data from street 2 to go into the street 1 field without loosing
the
street 1 data. Then I can delete the street 2 column to fit the Access
database
fields.

I can see two routes, both of which I am not able to figure out. I can
either find
a way to put the data together in Excel, or I can import the spreadsheet as
is, with
street 1 and street 2 columns still intact into a new Access table and then
use
whatever features Access has to transfer the data of street 2 into street 1
while
retaining the data of street 1. Then it is simple to delete the street 2
field.
(Then it is just a matter of a cut and paste append to transfer the new
table into
the preexisting database, which I know how to do.)

Any takers?

Thanks and Cheers,
Claudia
 
A common approach to importing data which needs to be "scrubbed" to fit into
a more relational data structure is to use an import table, and append
queries. You can use an append query to concatenate/combine the two address
fields together, then append that to your permanent table.

If you use an import table, you don't have to do anything to it (i.e., drop
a column/field) after you append the data to your permanent table. And if
you need to import more than one time, from the same source, you can empty
out the import table, then import the new data back into it, before running
the append queries.

--
Good luck

Jeff Boyce
<Access MVP>

"Sharing will save the world." <Sharing will save the
(e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top