Donations-Donor database--adding new donations and donors automatically?

[akdb]

I have created a donor and donation database for our non-profit. I currently have a table for donors and a table for donations.



I plan to upload donation information every week from an excel file. The donations upload includes a field for 'New' donors (meaning this donation is from a completely new donor).

Is there a way, when I upload the donations each week, to have 'New' donors automatically added to my donor table? Do I create a macro? Any direction is appreciated!!

[June7]

Are you linking to the Excel worksheet?

An INSERT SELECT might work, something like:

INSERT INTO Donors (ID, DonorName) SELECT ID, DonorName FROM ExcelLink WHERE New=True;

[akdb]

Are you linking to the Excel worksheet?

An INSERT SELECT might work, something like:

INSERT INTO Donors (ID, DonorName) SELECT ID, DonorName FROM ExcelLink WHERE New=True;

I am not linking to the Excel. I was importing the data into the Donations table.

Would your suggestion still work? (I am very new at Access! )

[June7]

You are using the import wizard? I don't think the wizard allows for filtered import.

You need to import data into two tables - Donors and Donations.

Your options are to link to the Excel and run the SQL action or open the Excel worksheet as an object in VBA and manipulate the object, reading one row at a time.