I have a spreadsheet that I want to link to Sharepoint as a list. I want to use Sharepoint to make updates to the spreadsheet as well as for lookups in other lists.
My problem is that the spreadsheet already has a data connection to a SQL database. The spreadsheet doesn't update the DB directly but the DB connection is used to keep the spreadsheet updated with new data edited directly in the DB. I don't
own the DB or the spreadsheet so cannot convince them to do their editing another way (directly from the info in the spreadsheet for example) so ...I HAVE to keep the existing connection to the DB.
My question is...is it possible to keep the connection to the DB AND link to Sharepoint?
OR..is there another solution?
View Complete Post