1

Information:
In a company, there are 6 people who use Excel to create budget. Unfortunately, there are lots of different copy of that file.

Problem statement:
I'am looking for a plug-in for excel that is linked to SQL server database. If you create a budget in excel, the data shall be saved in SQL server and it shall be easier for 6 people to edit and read the budget without having duplicate.

The data from the database shall be used for ETL process in data warehouse.

Any recommended plugin or similiar for Excel?

5
  • 1
    why not just utilize the built in sharing capabilities of Excel?
    – James
    Jun 11 '14 at 19:18
  • I don't understand. Do you have a tutorial for it?
    – What'sUP
    Jun 11 '14 at 19:44
  • What version of excel are you on?
    – James
    Jun 11 '14 at 19:57
  • It is Excel 2010.
    – What'sUP
    Jun 20 '14 at 10:45
  • Here are the directions for sharing in excel 2010: office.microsoft.com/en-us/excel-help/…
    – James
    Jun 20 '14 at 15:09
1

Simply put the excel spreadsheet on a shared drive and set the properties to "Shared" - this will allow multiple people to edit it at the same time. The exact location in the menus has changed several times so is version dependent, (but search the help for shared workbook), and all of the staff need to be using the same version of excel for this to work properly but it is far simpler than using a database.

2
  • Thank your for your help! My second request is to make the data to be applied to SQL server in relation to business intelligence.
    – What'sUP
    Jun 12 '14 at 11:10
  • 1
    @FullMetalGame: Please ask that second question at superuser.com
    – Nicolas Raoul
    Jun 20 '14 at 4:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.