Forum Discussion
Live Updates in Excel and SQL Server
Hello, Here is my scenario: I have created a table AutzenGIS2200 in a database Autzen2200. I then exported this table with blank data (but with schema) to an Excel spreadsheet and filled in the d...
- Seems like you may find some answers here https://community.powerbi.com/t5/Integrations-with-Files-and/best-way-to-push-data-from-excel-to-sql-server-no-of-rows-keep/td-p/107182 or
Seems like you may find some answers here https://community.powerbi.com/t5/Integrations-with-Files-and/best-way-to-push-data-from-excel-to-sql-server-no-of-rows-keep/td-p/107182 or
Hey,
Thank you for the links, I'll check it out and let you know what i find!
- let me know how you get on
Hey,
So I am trying two ways:
1. I use Server Management Studio with windows login. I used the links to reach out to one of the contributors and I am using a sample VBA script, trying to adapt it to my purposes.
2. I am considering downloading the SQL Spreads extension and trying it out.
In reference to one, I have run into an "error 91" and I am trying to figure it out.
Hey,
Thanks for the help, it looks like for my organization purposes, xlspreads is the way to go to make everyone's life easier.
