| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Worksheet to Database?
I know how to link an Access Database to a Spreadsheet, but how do you do the
reverse? Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking Worksheet to Database?
In Access choose File, Get External Data, Link.
To make this work properly I suggest you range name your data set in Excel. -- If this helps, please click the Yes button Cheers, Shane Devenshire "RoadKill" wrote: I know how to link an Access Database to a Spreadsheet, but how do you do the reverse? Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking Worksheet to Database?
That works if the data was in Excel and I want to create a new table in the
database. But my data is already in a table in the database. So I want to do the opposite. "Shane Devenshire" wrote: In Access choose File, Get External Data, Link. To make this work properly I suggest you range name your data set in Excel. -- If this helps, please click the Yes button Cheers, Shane Devenshire "RoadKill" wrote: I know how to link an Access Database to a Spreadsheet, but how do you do the reverse? Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking Worksheet to Database?
Well in that case, choose Data, Import External Data, New Database Query, and
find and select your database. Then proceed through the wizard. -- If this helps, please click the Yes button Cheers, Shane Devenshire "RoadKill" wrote: That works if the data was in Excel and I want to create a new table in the database. But my data is already in a table in the database. So I want to do the opposite. "Shane Devenshire" wrote: In Access choose File, Get External Data, Link. To make this work properly I suggest you range name your data set in Excel. -- If this helps, please click the Yes button Cheers, Shane Devenshire "RoadKill" wrote: I know how to link an Access Database to a Spreadsheet, but how do you do the reverse? Thank you |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking Worksheet to Database?
Ah, that did the trick. Thank you
"Shane Devenshire" wrote: Well in that case, choose Data, Import External Data, New Database Query, and find and select your database. Then proceed through the wizard. -- If this helps, please click the Yes button Cheers, Shane Devenshire "RoadKill" wrote: That works if the data was in Excel and I want to create a new table in the database. But my data is already in a table in the database. So I want to do the opposite. "Shane Devenshire" wrote: In Access choose File, Get External Data, Link. To make this work properly I suggest you range name your data set in Excel. -- If this helps, please click the Yes button Cheers, Shane Devenshire "RoadKill" wrote: I know how to link an Access Database to a Spreadsheet, but how do you do the reverse? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking charts to one database | Charts and Charting in Excel | |||
| Help with linking excel database to various word documents | Excel Discussion (Misc queries) | |||
| Linking Access Database to Excel | Excel Discussion (Misc queries) | |||
| Linking an Excel database to MS AutoRoute | Excel Discussion (Misc queries) | |||
| linking customer database to invoices in excel | Charts and Charting in Excel | |||
Linear Mode
