| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sharing access to an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
| Joining only certain columns to a spreadsheet. | Excel Discussion (Misc queries) | |||
| Print excel spreadsheet with access | Excel Discussion (Misc queries) | |||
| Run Access macro from Excel Spreadsheet | Excel Discussion (Misc queries) | |||
| cannot access excel spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
