leezac
asked on
Editing Excel Worksheets when data stored in Oracle
I will have worksheets saved to Sharepoint where users will enter data that will be populated into MSAccess then into Oracle. I have a delima on how to handle editing of data using the same Excel spreadsheets (not connected to Oracle) and how to handle updating and allowing the User to see data they have entered. The issue is once the data has gone into Oracle someone else may have changed it.
I need Expert's advice on how might handle situation. Thanks in advance.
I need Expert's advice on how might handle situation. Thanks in advance.
Can you extract the Oracle data into the spreadsheet on one tab and highlight changes on the entry tab?
Reg
Reg
ASKER
slightw -- yes - macro in MSAccess to Import
ASKER
slightw - management is concerned that the users will not know what the data already is stored in Oracle. They will not right now be able to query from Oracle.
I think you mis-understood my statement:
I assumed the Excel spreadsheet needs the macro to update the databases.
How does the database get updated currently?
Do you have sharepoint set up to check-out/check-in the document?
I assumed the Excel spreadsheet needs the macro to update the databases.
How does the database get updated currently?
Do you have sharepoint set up to check-out/check-in the document?
ASKER
This is a new process under development - I am looking for input on Solutions....
I think check in and check out solution for Sharepoint would be one.
If connected to Oracle then a Button would be feasible.
I am just looking for all possibilities and that I have thought through all options.
Thanks!
I think check in and check out solution for Sharepoint would be one.
If connected to Oracle then a Button would be feasible.
I am just looking for all possibilities and that I have thought through all options.
Thanks!
From what you have posted, I would really rethink the whole, Excel to Access to Oracle and the front end is SharePoint.
Since you are asking about possible options, can we ask why you want to use Excel for data entry? Possibly a little high level description of the app?
That said:
You might look at the Excel events you have available and when they fire.
for example from a quick Google I see a Workbook_BeforeSave. You might be able to write the code there to do your processing to the database. What I don't know is if BeforeSave can fire and the workbook actually NOT get saved.
Since you are asking about possible options, can we ask why you want to use Excel for data entry? Possibly a little high level description of the app?
That said:
You might look at the Excel events you have available and when they fire.
for example from a quick Google I see a Workbook_BeforeSave. You might be able to write the code there to do your processing to the database. What I don't know is if BeforeSave can fire and the workbook actually NOT get saved.
ASKER
Ok - thanks - I will look up - but Sharepoint we are just saving to check in and out. Does that still affect your answer>
ASKER
I like regmigrants answer
Slightw - will the workbook_beforesave get data from Access database or save to Access Database?
Slightw - will the workbook_beforesave get data from Access database or save to Access Database?
ASKER
High level it is just an Excel data entry form where mutliple users will be entering data and that data is accumulated in database. Then users may want to make revisions to said data, but may not be the only person that has revised data. So they need to see what was changed by others.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If so, I'm not understanding the question.