| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Joining data from 2 spreadsheets into 1 sheet
G'day Versie
Just a thought, something to consider: Instead of exporting the Access Data to Excel and merging there. Import the Excel data into the Access DB and give the Table a different name. Create a UNION query to merge the 2 datasets based on eeID. Then export that combined data back into Excel.. HTH Mark. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Joining up data points | Charts and Charting in Excel | |||
| joining spreadsheets together for reports and queries? | Excel Programming | |||
| VB code for joining column data. | Excel Programming | |||
| Joining rows with different data | Excel Programming | |||
| Compare data of two excel spreadsheets in a third sheet | Excel Programming | |||
Threaded Mode
