Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i join 2 excel spreadsheets into access & import it back
how do i combine 2 different excel spreadsheet in access & import it back to
excel as 1 spreadsheet. This is what i am trying to accomplish turn 2 spreadsheets into 1 using an item number as the common denominator the new spreadsheet has to have all the updates from both spreadsheets. Thanks, I welcome any and all suggestions. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i join 2 excel spreadsheets into access & import it back
If both spreadsheeets have the same fields then you can import them and run
an append query adding either one to the other. You may also be able to just import one and then copy and Edit - PasteAppend to the existing table. Hope that helps. "Connie" wrote: how do i combine 2 different excel spreadsheet in access & import it back to excel as 1 spreadsheet. This is what i am trying to accomplish turn 2 spreadsheets into 1 using an item number as the common denominator the new spreadsheet has to have all the updates from both spreadsheets. Thanks, I welcome any and all suggestions. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i join 2 excel spreadsheets into access & import it back
Could you use VLOOKUP formulas in the 3rd sheet to look up data in each of
the seperate sheets rather than importing and exporting? "Connie" wrote: how do i combine 2 different excel spreadsheet in access & import it back to excel as 1 spreadsheet. This is what i am trying to accomplish turn 2 spreadsheets into 1 using an item number as the common denominator the new spreadsheet has to have all the updates from both spreadsheets. Thanks, I welcome any and all suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create form in Access, use as frontend for Excel | Excel Discussion (Misc queries) | |||
Excel to Access Problem | Excel Discussion (Misc queries) | |||
Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel and Access talking | Excel Discussion (Misc queries) |