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, 2014 at 19:18
  • I don't understand. Do you have a tutorial for it? Jun 11, 2014 at 19:44
  • What version of excel are you on?
    – James
    Jun 11, 2014 at 19:57
  • It is Excel 2010. Jun 20, 2014 at 10:45
  • Here are the directions for sharing in excel 2010: office.microsoft.com/en-us/excel-help/…
    – James
    Jun 20, 2014 at 15:09

1 Answer 1

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. Jun 12, 2014 at 11:10
  • 1
    @FullMetalGame: Please ask that second question at superuser.com
    – Nicolas Raoul
    Jun 20, 2014 at 4:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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