Joining an Excel spreadsheet to another using Access
 

Hey guys, any help on this would be very great.

I currently have two excel spreadsheets.

Excel Spreedsheet 1 contains 50,000 Company Names + CEO, Address, Phone
Number, Site
Excel Spreadsheet 2 contains 3,000 Company Names

All the companies in Spreadsheet 2 are available in Spreadsheet 1.

My purpose is to Have Spreadsheet 2 containing the 3000 company names +
the information found in spreadsheet 1. I did this once in Access by
joining the two tables but for the life of me cannot remember the
process within the Query that would spit out a table from spreadsheet 2
for me. Thank you.

Joining an Excel spreadsheet to another using Access
 

I would be inclined to stick with Access for this. Import the one spreadsheet
into one table and the other spreadsheet into the other. Create a query from
the two tables joining the two table on the Company name (by default this
will be an inner join that will only return records where you have a match)
Drop the fileds you want into the query table and run the query. It should be
very fast.

In Excel you could do this via Vlookup statements but this is going to be
VERY slow in comparison to Access...
--
HTH...

Jim Thomlinson


"Vincent Q. Dang" wrote:

Hey guys, any help on this would be very great.

I currently have two excel spreadsheets.

Excel Spreedsheet 1 contains 50,000 Company Names + CEO, Address, Phone
Number, Site
Excel Spreadsheet 2 contains 3,000 Company Names

All the companies in Spreadsheet 2 are available in Spreadsheet 1.

My purpose is to Have Spreadsheet 2 containing the 3000 company names +
the information found in spreadsheet 1. I did this once in Access by
joining the two tables but for the life of me cannot remember the
process within the Query that would spit out a table from spreadsheet 2
for me. Thank you.