Insert Into Join

[Guest]

Hello,

I have two tables, one with member details and one with comments joined by
memberid (autonumber). I have a csv file that loads new records onto the
system and I need to append to the member table, and add a comment linked to
that new record to say we have received the new member.

I am right in thinking you cannot append to a Inner Join query? Is there any
way past this as the comment will be different to each record?

Many thanks

James

 

[Jeff Boyce]

James

I don't have a clear picture of your csv/data file, and how that might be
related to your comments table. And it isn't clear if your csv/data file
has the memberIDs, or if you are creating those in your member table when
you load the csv/data file.

If all the data is in the csv, you could use two appends, one to members,
one to comments.

For more specifics, send more specifics!

 

[Guest]

Hi Sorry,

The CSV is only member details no memberid my system creates this. The
comments need to say something like "Member Registration received from HLD"

'Member' and 'HLD' will change depending on various values in the CSV.

If I do have to do them seperatly any idea on how to get them linked again?

manyt hanks

James

 

[Jeff Boyce]

James

How do you/Access know that a member is a new member, and needs a new ID?

How do you/Access know that a "new" member named "John Smith" is NOT the
same "John Smith" that's in your database already?

I still don't have a clear picture...

Jeff Boyce
<Office/Access MVP>

 

[Guest]

Hello,

The CSV file comes from Sales so they will all be new people. If they are
already on the system it will be an UPdate which is a different CSV file from
somewhere else.

They will all be new people.

 

[Jeff Boyce]

James

OK, the "new" folks come in a "NewFolks.csv" file. You can load them with
an append query. If you also have a field for [DateLoaded], you can use
that to identify your rows/IDs for new folks.

Your "updated" folks come in an "UpdatedFolks.csv" file. If that csv file
does NOT include the already existing record ID for each person, you have NO
way to tell John Smith from his son, John Smith, nor from another John Smith
across town, nor from "J. Smith". How do you/Access know which row to
update?

Regards

Jeff Boyce
<Office/Access MVP>