Joining an Excel spreadsheet to another using Access

  • Thread starter Thread starter Vincent Q. Dang
  • Start date Start date
V

Vincent Q. Dang

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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel spreadsheet to Word document 1
Excel Access - importing an excel spreadsheet 0
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
joining spreadsheets together for reports and queries? 1
Excel Spreadsheet display with autorefresh 1
Opening an Excel spreadsheet from within an Excel spreadsheet 2
Using VBA to change Excel layouts 2

Back
Top