rik1471

I have a database with a table "Customers", which holds customers email addresses. I have a text file with 1000 addresses which I want to add to bottom of the the table, each email on a new record, how do I import the data? If I paste it into an excel spreadsheet and try to Import, it will only let me import it to a new table?

The column in the table is named custEmail

Anyone help??

Cheers,

Rik.

rik1471

btt.

ChrisB

Import into a new table and then use an Append Query to shove the new records into the existing table.

DJ Dunk

iTrader: (5)

This is exactly what I am trying to do. I have 150,000 records spanned across 3 tables (because it wouldn't let me load into a current table ) and am now trying to work out this append query. Talk about over complicated

ChrisB

It's easy

What are you struggling on?

DJ Dunk

iTrader: (5)

Think I may have cracked it, I'll get back to you
. . . . .

rik1471

help!

Nicks VR4

as above
Import to a new table and use append query to add into existing table

ChrisB

What's the problem? Can you send me the data?

rik1471

I must be missing something here,

I have the database. 2 tables in question:

Table1 name, Imported: contains 1 field named emails.
Table2 name, sfCusomers: contains multiple fields of customer data, one of which is custEmail.

I am trying to append the data from table1 to the end of table2 in the custEmail field.

When I run the following query:



It asks me if i want to 697872 rows!!! There are only 1302 records in the imported table and 536 in the sfCustEmail table. Funnily enough these 2 multiplied = 697872, so I must be doing something wrong.

I'm a beginner when it comes to Access, so any assistance would be appreciated.

Rik

JohnJ

Youneed to have a 'common' field in each table in order to link the two tables together, e.g. Unique Customer ID. Once you have this you can create a new field in your Customer Table to hold the email and use an 'update' query to populate this new field with the matching email from the loaded table.

The reason you are getting >600,000 record being added is because Access is linking each record in one table with every record in the other, therefore you are creating 1300ish * 500ish new records.

rik1471

- cheers