Friday, September 23, 2016

Troubleshooter of Error: create a simple table viewer/editor in excel from SQL server

create a simple table viewer/editor in excel from SQL server

All-I am hopeful I can get some assistance (or at least pointed in a direction) to be able to accomplish a relatively "simple" table viewer/editor in excel 2007/2010.I have a 2008 SQL server database, that I would like to be able to bring in the table information to an excel sheet.I already have connections to the database through ADODB.Ideally, I would like to have a dropdown on the excel sheet that lists all the table names.Once a name is selected, and a load button is pushed, it would bring in the table (column names and all row data) a couple of cells down from the dropdown, to a single cell defined named range (does this need to be bigger?)Then, I would also like to be able to create a save process, so that if cell data is changed within the table, I could click another button that would then write back the changes made.I have a feeling this may be a bigger project than I am expecting, but would appreciate any help or guidance offered, thanks!

Keys to the Problem create a simple table viewer/editor in excel from SQL server

For better suggestions related to Excel using ADODB connection to SQL server you may post your query in the link below:http://social.msdn.microsoft.com/Forums/en/category/sqlserver

Using Windows troubleshooter:

Click on Search on Charm bar and type Troubleshooting. Click on the very first option.

A new window will open. Click View all from the left pane.

Scroll down to the bottom and click on Windows update.

Troubleshooter window for Windows update will pop up. Click on NEXT. It may ask you for administrative permission.

The troubleshooter will automatically detect problems and fix it.

Now, close this window and try download/install the app which was previously showing error.

Recommended Method to Fix the Problem: create a simple table viewer/editor in excel from SQL server:

How to Fix create a simple table viewer/editor in excel from SQL server with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system. Open it, and it will perform a scan for your computer. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.