Merging multiple tables, and extracting the duplicates to a CSV file.

[lostgirl]

Hey all

I have tried to scouring the web for help on this particular problem, but i can't seem to find an answer.

We are a non-profit that does blind mailings for our membership drive.
The company who we buy names and addresses from sends us a delimited file that has these fields as the headings

" ID, FULLNAME,COMPANY, ADR1, ADR2, CITY, STATE, ZIP, FIPS"

Once they send out the mailings, people then send in back a remit slip with a contribution that gets scanned through a program that creates a file that gives us these titles

"ALT ID, AMOUNT PAID, RUN DATE, TENDER, FUND, PURPOSE, SOLICITATION, MEMBERSHIP QUESTION, MEMBER TYPE, CONSTITUENT TYPE, SEGMENT"

The "ALT ID" and "ID" are the same in both tables.

I need to find a way to merge the tables and combine the fields that have the same ID # , and then have it create a csv file that reads like this (see below) for only the files of the people that responded so that I can import it into our membership software.

"Alt ID","Title","First Name","Middle Name","Last Name","Suffix","Address1","City","State","ZIP","cty_code","Amount Paid","Run Date","Tender","Fund","Purpose","Solicitation","Membership Question","Member Type","Constituent Type","Segment"

Can someone please help??

I am a complete noob with access.

thanks in advance guys!

 

[pr2-eugin]

Hello lostgirl, Welcome to AWF

I know you mentioned you are new, but this might need a lot more work than you think. First, import the second file into a Temp table, then you need to JOIN the temp table with the Actual data table, extract the information you need by using a Query. Export this Query as a CSV file.

Can be automated, but will take much more coding than you expect.

 

[lostgirl]

Hi There thank for the welcome and quick reply

Is there anyway you can maybe walk me through this?
All those words seemed like gibberish to me.