Excel to SQL
Вставка
- Опубліковано 11 жов 2024
- Excel to SQL
www.sql-excel.com
One of the things that I see IT software development people struggle with is SQL to Excel integration.
SQL to Excel integration unfortunately has been made unnecessarily cumbersome because of the rather primitive awkward way Microsoft has chosen to implement SQL to Excel communication.
That's why I created a way to solve SQL to Excel integration once and for all. It doesn't have to be hard. It doesn't have to take a long time to develop software/spreadsheets which integrates SQL to Excel.
And in fact, Excel is the PERFECT platform for integrating SQL to Excel database access. Excel is PERFECT for rapid application development (RAD).
The right out-of-the-box though, SQL to Excel integration is painful in Excel. Not only that, but the way SQL to Excel was implemented, it created tremendous opportunity for the data to be structured wrong, or at minimum, misinterpreted.
Let me give you one specific example.
I called this example "data drift." What do I mean by "data drift?"
It's when you have a SQL table and it's imported into Excel. The data into Excel spreadsheet is static, imported only one time during an Excel session. However, the data in the SQL table continues to be updated by different user departments in the company.
In essence, the SQL to Excel "data drifts" more and from the corporate database on the server. This is where Microsoft's way of integrating SQL to Excel functionality falls far short.
As you can imagine, this can cause tremendous problems with departments and users. And it's one of the main reasons, SQL to Excel integration projects are so frustrating. I though there had to be a better way of implementing SQL to Excel integration.
My new SQL to Excel tool set I developed, solves that problem once and for all. Because now the data can be refreshed either through seamless and transparent SQL to Excel, or Excel to SQL integrations at key checkpoints and function points in the spreadsheet.
The best part, is that SQL to Excel integration is ALL transparent to the user. While there is updating going on in the background/behind the scenes, the user is unaware of the SQL to Excel communication going on.
Once my way of SQL to Excel has been implemented, the problem of data drift literally disappears. Because it looks like to the user they are really doing SQL to Excel importing and later updating the SQL database IN REAL-TIME.
SQL to Excel, or Excel to SQL doesn't have to be hard to develop either. In fact with my tools, if you're a software developer, I've made SQL to Excel a snap. In less than a few minutes from now, you can be impressing your boss or the users with what you can do with Excel. You'll be able to make Excel do backflips, things you, as a software developer always wanted it to do.
Using my SQL to Excel toolset, rapid application development (RAD) is a reality inside Excel. I urge you to check out my website at www.sql-excel.com.
Once you do, you'll never go back to the slow, error prone, painful way of implementing SQL to Excel integrations in the future. SQL to Excel integrations from here forward will actually be fun and make your users extremely happy and confident in the data.
Check it out at: www.sql-excel.com
• Excel to SQL
Excel to SQL
Nice work.
For retrieval, I'd urge use of MS Query instead for a few reasons:
[1] It's already part of XL. No addins. No VBA
[2] No need to guess how many rows will be returned.
[3] No formulas to slow things down.
Like your solution, MS Query can be parameter based and refreshed based on triggers including events such as workbook open - again - without VBA.
Cool! Easy and ingenious.
There is already a decent add-in for Excel which helps to connect with SQL Server www.devart.com/excel-addins/sql-server.html
It will help you quickly and easily load data from SQL Server or SQL Azure to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to SQL Server. It enables you to work with SQL Server data like with usual Excel worksheets
plus.google.com/108969404877693764299/posts/Km3RMuUkxXC or
total game changer! are you glowing and levitating over the computer like buddha? Thank you for putting your genius on hold to share this.
the video is good but have few question and maybe you could do more videos about:
1- how did you create the function that gets triggered?
2- what is the correct syntax in excel 2010 to connect directly to SQL
3- what if we don't want to use Northwind DB, i only have SQL express and how do i connect?
thank you
Great presentation! Thank you! Would you by any chance have an example with INSERT from Excel to MS SQL Server? Thank you.
Hello!
I would like to ask do you know how to connect a system that inputs data directly to Excel? if the user inputs a data it directly goes to Excel.. Thank you in for the answer :)
Excellent Explanation
How the function SQLServerExec got created?
Could you please provide some detailed info? Thanks
Could you please kindly explain how I can use these sql queries in a form in Excel.
This form should be able to retrieve and update data in sql server. How can I go about this please? Thanks
Link does not work any sujestions
I was able to hear fine but screen was fuzzy. Is there a way to look at it more clear?
Je n'arrive pas à télécharger le complément proposé. Puis avoir le lien par mail ?
nice tutorial!
awesome intro!!!
Can u tell me the way if I put input in excel and that data added directly in my backend without copy paste
great idea, but where can i get the add-in? the site is down
thanks! very helpful
I tried to create a simple application to import the data from excel to mysql
Existe t il une version en français ?
blurd I cannot read what you doing.
please make it readable.
thank you.
Because my Table has 85 columns, and I can't make structure manually.I found very fast and elegance decision Search - ( excel2mysql es ) - online very useful tool. Converts .xsls , xls , csv files to SQL code for easy import in database.
Hi there, the link now longer works. is there way i maybe able to access the download?
Omg...
Empower your users?
This is how you break databases
please teach me on how to create simple program in excel and mysql?
how to connect ms excel and mysql?
Ailene, Could you please review the link, Hope, you get the answer for your question,
www.excel-sql-server.com/excel-sql-server-import-export-using-vba.htm
I have an sql file with long datas, which was sended me by e-mail. Can you please clarify me how I can see it or convert it to excel?
can i reach you by email? I have a question about importing from excel to sql.
Sorcery!
Search - ( excel to sql convert es ) - online very useful tool. Converts .xsls , xls , csv files to SQL code for easy import in database.
Any chance I could contact you by email as well? I also have a few questions on a project that is similar to your video and it would be very helpful for me using your method.
Because my Table has 85 columns, and I can't make structure manually.I found very fast and elegance decision Search - ( excel2mysql es ) - online very useful tool. Converts .xsls , xls , csv files to SQL code for easy import in database.
Nice tool! It really depends who will be using Excel to update SQL and whether it is a one-time requirement or an ongoing requirement. There are some great options for the one time stuff, especially if you as the IT person is going to load the data yourself. However with some programming work, one can create a very user-friendly and robust Excel workbook that can indeed be used repeatedly by users to not only import data into SQL tables (whether it is SQL Server, MySQL etc. does not matter).
Because my Table has 85 columns, and I can't make structure manually.I found very fast and elegance decision Search - ( excel2mysql es ) - online very useful tool. Converts .xsls , xls , csv files to SQL code for easy import in database.