Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHY Cant anyone answer my question
Hi
I have a spread sheet that read off access but i was wondering if i change the spread sheet data in excel can access read this to update the data in access Also can excel update in realtime or do i have to fresh refresh button all the time thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHY Cant anyone answer my question
Ado
Please be aware that you are asking to know how to make MS Access do something it is not capable of doing. One MS Access table cannot be linked to multiple Excel lists. You can, however, create a separate link in MSA to each Excel list and that process was explained to you by Jim Jackson in your original post. Even though you couldn't create those 150 Excel files from MSA in one single step, you can re-combine them in a few steps if you create a Union Query that will harvest the data from the files and load it to the MSA table. Note: You will NOT be able to *link* that one table to the 150 files. There will be 150 linked tables that will be consolidated. Also, I believe the links only work one way. You can change the data in Excel and refresh MSA, but you can't change it in MSA. The link is read-only. Whenever you need to update the data in MSA, you could either run the queries manually or create a macro to run them for you. If you're interested in that approach, the MS Access forums would be your best resource. I hope that helps. *********** Regards, Ron XL2002, WinXP "CmK" wrote: Hi I have a spread sheet that read off access but i was wondering if i change the spread sheet data in excel can access read this to update the data in access Also can excel update in realtime or do i have to fresh refresh button all the time thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHY Cant anyone answer my question
Hi,
Actually an Access table can be linked to an Excel range (best if you name the range) and then when Excel's data changes the Access table updates. Probably the best way to do this is to choose File, Get External Data, Link Data, change the Files of type to Excel and locate your Excel file... Remember to Name the range in the Excel file first. -- Cheers, Shane Devenshire "CmK" wrote: Hi I have a spread sheet that read off access but i was wondering if i change the spread sheet data in excel can access read this to update the data in access Also can excel update in realtime or do i have to fresh refresh button all the time thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHY Cant anyone answer my question
My apologies, CmK, for confusing you with Ado.
I saw your posts in the related Ado thread and I thought you were Ado with a new newsgroup name (it happens). *********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: Ado Please be aware that you are asking to know how to make MS Access do something it is not capable of doing. One MS Access table cannot be linked to multiple Excel lists. You can, however, create a separate link in MSA to each Excel list and that process was explained to you by Jim Jackson in your original post. Even though you couldn't create those 150 Excel files from MSA in one single step, you can re-combine them in a few steps if you create a Union Query that will harvest the data from the files and load it to the MSA table. Note: You will NOT be able to *link* that one table to the 150 files. There will be 150 linked tables that will be consolidated. Also, I believe the links only work one way. You can change the data in Excel and refresh MSA, but you can't change it in MSA. The link is read-only. Whenever you need to update the data in MSA, you could either run the queries manually or create a macro to run them for you. If you're interested in that approach, the MS Access forums would be your best resource. I hope that helps. *********** Regards, Ron XL2002, WinXP "CmK" wrote: Hi I have a spread sheet that read off access but i was wondering if i change the spread sheet data in excel can access read this to update the data in access Also can excel update in realtime or do i have to fresh refresh button all the time thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHY Cant anyone answer my question
On Feb 24, 9:56 am, CmK wrote:
Hi I have a spread sheet that read off access but i was wondering if i change the spread sheet data in excel can access read this to update the data in access Also can excel update in realtime or do i have to fresh refresh button all the time thanks To refresh, open worksheet that has your imported data from ACCESS, click on External Data Range Properties, Click on Refresh every and tell how often you want it to automatically refresh. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Question, But No Answer | Excel Worksheet Functions | |||
Formula question...I belive row is the answer...but need help | Excel Discussion (Misc queries) | |||
Templete question...I hope there is an answer | Excel Worksheet Functions | |||
help question so basic I can not find answer | Excel Discussion (Misc queries) | |||
question requires answer | Excel Worksheet Functions |