Possible to handle database insert, update and select in excel?
 

Hi all,

I have a rather big spreadsheet that is use by a few different people for
for some calculations. There are a lot of data that need to be inserted into
different worksheets of the spreadsheet. The day-to-day work in this works
fine, but a problem occurs whenever I make an update to the spreadsheet. All
my users then need to download my new version of the spreadsheet and
manually spend a few hours to move the data from the older version to the
never version. Obviously this is not a good solution, and I am looking for a
way of separating the data in the spreadsheet from the logic. If I could
store the user inserted data external from the spreadsheet, load the data
into the spreadsheet whenever it is opened, and save the data to the external
source whenever the spreadsheet is saved, I would have a much less
troublesome life. ;)

I would believe that storing the data in a database (such as SQL server)
would be the optimal solution. I've been searching the excel documentation
and the internet, but I can not seem to find what I am looking for.

I've found ways of exporting data from a database into Excel, and I've found
ways of exporting excelspreadsheets into a database. But these methods deal
only with whole spreadsheets, and not with the information in some specific
cells in the spreadsheet.

Basically, what I would like to do is to execute functions similar to
select, insert and update queries of SQL in the excel spreadsheet - and my
question to the readers of this forum is whether there is a way of doing this?

I am not scared of creating a few macros in VBA if this would be a way of
solving the problem.

thankfull for any help,
anders