Avatar of kw66722
kw66722
 asked on

Excel to SQL

I have a SQL database in Azure. My client wants to be able to connect to one of the tables in excel and update and add to the data from the spreadsheet directly in real time.  

Is there a way to do this?  

I had created an application in .net using a dataview they did not like it because not all the features that they use in excel are available. Most importantly easily increasing the font size, and filtering the data.
Microsoft ExcelMicrosoft SQL Server.NET ProgrammingVBA

Avatar of undefined
Last Comment
kw66722

8/22/2022 - Mon
YZlat

Let me clarify - you want the client to connect to the database from Excel spreadsheet?

The client can connect to Azure SQL from Excel spreadsheet by going to Data tab, then clicking 'From other sources" button, selecting "From SQL Server".

Then the connection wizard will pop up and prompt for Azure SQL server name and login credentials. Then the user will be prompted to select the database and table in question
kw66722

ASKER
When I do that the data is imported to the excel spreadsheet and any changes made are not saved on the server.  I need the changes made to be added to the Azure database in real time.
ASKER CERTIFIED SOLUTION
Jim Horn

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
kw66722

ASKER
I redesigned the table based on the data integrity issues. I will read your article.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
kw66722

ASKER
I reviewed the article I did not see where the solution presented updates sql or where an inserted row is added to the sql table
Martin Liss

I've requested that this question be deleted for the following reason:

The question has either no comments or not enough useful information to be called an "answer".
kw66722

ASKER
This answers part of the question. I will submit another question to answer the rest.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.