Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging in Excel from Word, Excel, or Access
Can you do a "merge" in Excel with data from Excel, Word, or Access?
I have a list of names (in Access and Excel) which I would like to put in a specific cell in Excel. There are 80 names, so I would prefer to not have to type them individually. I can do it in Word, but I must be missing something in Excel. Can it be done? Any help would be greatly appreciated!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging in Excel from Word, Excel, or Access
From Access you can import or link Excel spreadsheets and if you have a table
in access you can export that table to a excel spreadsheet. "RS" wrote: Can you do a "merge" in Excel with data from Excel, Word, or Access? I have a list of names (in Access and Excel) which I would like to put in a specific cell in Excel. There are 80 names, so I would prefer to not have to type them individually. I can do it in Word, but I must be missing something in Excel. Can it be done? Any help would be greatly appreciated!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging in Excel from Word, Excel, or Access
Thanks, Andy. However, want I really need to know is if I can take my names
from Access and import them (like a mail merge) into separate Excel worksheets .. i.e. a separate sheet for each name on my list into one name field (Name). Thanks ... RS "Andy" wrote: From Access you can import or link Excel spreadsheets and if you have a table in access you can export that table to a excel spreadsheet. "RS" wrote: Can you do a "merge" in Excel with data from Excel, Word, or Access? I have a list of names (in Access and Excel) which I would like to put in a specific cell in Excel. There are 80 names, so I would prefer to not have to type them individually. I can do it in Word, but I must be missing something in Excel. Can it be done? Any help would be greatly appreciated!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Print Excel charts in Word 2003 with fixed size | Charts and Charting in Excel | |||
Merging excel data into word | Excel Discussion (Misc queries) | |||
Error message in Excel after exporting Access query to Excel | Excel Discussion (Misc queries) | |||
Easiest Way to have access functionality in Excel or vice-versa? | Excel Worksheet Functions |