Copy data to existing table?

[Guest]

I want to COPY data (not import another table) to an existing table I set up.
How do I do this?

I have a table with address info and I want to copy the LAST NAME column of
data from another database into my existing table without adding another
table to my database.

 

[Guest]

Hi,
import the other table and then run an append or update query, which will
append or update the data you want into your current table. Then delete the
imported one.
HTH
Good luck

 

[John Vinson]

Hi,
import the other table and then run an append or update query, which will
append or update the data you want into your current table. Then delete the
imported one.

Or you can use File... Get External Data... Link rather than File...
Get External Data... Import; this may be slower to run but it will be
quicker in the long run since you don't have the overhead and bloat of
creating and then deleteing a table.

John W. Vinson[MVP]

 

[Guest]

That would work as well
--
Oliver
Admin Specialist & Computer Science Major @ UMD - Go Terps -
http://www.oli-s.de

 

[Guest]

I was going to copy EACH column from an existing table into MY table that I
created. For example, the existing table has LAST NAME, FIRST NAME, ADDRESS,
CITY, etc (all as separate columns) and I wanted to copy each column into MY
table.

 

[John Vinson]

I was going to copy EACH column from an existing table into MY table that I
created. For example, the existing table has LAST NAME, FIRST NAME, ADDRESS,
CITY, etc (all as separate columns) and I wanted to copy each column into MY
table.

An Append Query would be the right tool for this. May I ask why you
want to store the same information redundantly in two different
tables? This is generally a Bad Idea...

John W. Vinson[MVP]

 

[Guest]

I created an alumni database with a bunch of fields. I later found out from
the school that someone had already created a database with "basic" info
(name, address). I like my database because it is very detailed (a lot of
fields), so I wanted to input the names that someone had already typed in
their database into my new database. They had already inputted approx 1400
names and addresses and I didn't want to re-type them into my database.

Anyhow, I found a way to do it by copying and pasting. The main thing I had
to do was have as many records in MY database as the OTHER database had. So,
I just created 1400 records (basically blank records) in MY database, went
into the OTHER database and clicked on the column heading that I wanted to
copy (say FIRST NAME), clicked COPY, went into MY database, clicked on MY
column named FIRST NAME, and then clicked PASTE. It asked me if I wanted to
copy 1400 records and I said YES. I did this for each column I wanted to
copy (LAST NAME, ADDRESS, CITY, ZIP, etc). Wallah!

It would only work if MY database had enough records (or more I would
assume) to match the OTHER database. For example, if MY database only had 50
records, then it would only copy the first 50 records from the OTHER database.

Thanks.

 

[John Vinson]

I created an alumni database with a bunch of fields. I later found out from
the school that someone had already created a database with "basic" info
(name, address). I like my database because it is very detailed (a lot of
fields), so I wanted to input the names that someone had already typed in
their database into my new database. They had already inputted approx 1400
names and addresses and I didn't want to re-type them into my database.

Anyhow, I found a way to do it by copying and pasting. The main thing I had
to do was have as many records in MY database as the OTHER database had. So,
I just created 1400 records (basically blank records) in MY database, went
into the OTHER database and clicked on the column heading that I wanted to
copy (say FIRST NAME), clicked COPY, went into MY database, clicked on MY
column named FIRST NAME, and then clicked PASTE. It asked me if I wanted to
copy 1400 records and I said YES. I did this for each column I wanted to
copy (LAST NAME, ADDRESS, CITY, ZIP, etc). Wallah!

It would only work if MY database had enough records (or more I would
assume) to match the OTHER database. For example, if MY database only had 50
records, then it would only copy the first 50 records from the OTHER database.

Thanks.

I'm awfully sorry you did all this work... :-{(

A very simple Append query would have done 1400 (or 140,000) records
in seconds, without the need to create blank "placeholder" records.
Copy and paste is fine for spreadsheets but it's not really a
relational database operation.


John W. Vinson[MVP]

 

[Guest]

Since I am new to Access and have taught myself entirely how to use it I
don't know how to do an Append Query. I'll look into it now. I'm used to MS
Word and Excel using copy and paste...