Help with merge and extraction?

[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","ct y_code","Amount Paid","Run Date","Tender","Fund","Purpose","Solicitation","Me mbership Question","Member Type","Constituent Type","Segment"

Can someone please help??

I am a complete noob with access.

thanks in advance guys!

 

[namliam]

Do you know how to import the files into access???
This may be a good place to start:
https://www.google.nl/#q=import+text+delimited+file+into+access

once imported it should be quite easy to make a query and join on the ID to output the text file you seem to want.

 

[pr2-eugin]

Do you know how to import the files into access???
This may be a good place to start:
https://www.google.nl/#q=import+text+delimited+file+into+access

once imported it should be quite easy to make a query and join on the ID to output the text file you seem to want.

Feels like the same story said over again : http://www.access-programmers.co.uk/forums/showthread.php?t=261406

 

[lostgirl]

That was me as well!
I'm desperate to find some solid help, not just a blanket answer of google this or it's more then you can do.

I wish SOMEONE could just be helpful.

 

[namliam]

well the blanket answer of google, if you had bothered to check it, you would find a video on how to import a tab-seperated text file. the steps are very identical only placing a tick mark else where but that should seem very self evident.

1) Create a new blank database
2) Here it already starts depending on the version you are using, I am going to assume its a relative new-ish version.... External data > Import text file
3) Browse to the file in question, click OK
4) Choose "Delimited", click next
5) Make sure the Comma is selected, depending on if your first row has headers, tick the check box that sets it thus. Click next
6) Click next
7) Check the "Choose my own primary key" and pcik ID from the list, click next
8) Give the table a name, please follow a good naming convention
Please go thru: http://www.access-programmers.co.uk/forums/showthread.php?t=225837&highlight=naming+convention
9) Repeat 2 thru 8 for the second file
10) Under database tools, click Relationships and add your two tables
11) Click and hold on your ID field, now drag it on top of your ALT ID field in the other table, this should create a line between them. Close and save the window
12) Under Create, choose query design, add your two tables (which should automagicaly get the line between them since we created it under 11) now add your columns you want to see in the order you want to see them
13) Click on save and give your query a proper name (remember the naming convention)
14) click on "View" which should be top left of your screen under Design in the ribon. Presto you are good to go.

I hope this helps you along, good luck with this project... Got a feeling you are going to need it