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 |