SaveToDB FAQ

SaveToDB FAQ

Is it possible to use the localized names for table columns, output columns of views and stored procedures?
Yes. Database servers support the localized names.
However, if you want to save data changes back to a database, then the names should conform to rules for stored procedure parameter names.
For example, space and non-alphanumeric symbols are not supported in parameter names.
At the same time, we recommend to use English names and configure the data translation.
Can I use spaces in column names of tables and views?
Yes, you can. However, these fields cannot be used in procedures parameters for saving data and handling events as they do not conform to requirements for procedure parameter names.
We advise to use English names of fields without spaces and use the data translation within Microsoft Excel.
I cannot save Excel table changes to a database. What to do?
See Required conditions to save changes.
I receive a message of operation timeout when saving changes of a big data table. How can I increase the operation timeout?
Change the Command Timeout using the Options dialog box.
I receive a message of operation timeout when publishing data. How can I increase the operation timeout?
Change the Command Timeout using the Options dialog box.
Why does the Microsoft Excel Refresh menu not work for MySQL?
The SaveToDB add-in uses the .NET provider for working with MySQL by default.
It allows you to work with MySQL without installing additional components. You may load and save data using the SaveToDB add-in.
For the full support of MySQL in Microsoft Excel, you have to install the ODBC driver from MySQL website and use this driver when connecting to MySQL database.
Why does the Microsoft Excel Refresh menu not work for Microsoft SQL Server Compact?
Microsoft Excel does not support working with Microsoft SQL Server Compact.
The SaveToDB add-in uses the .NET provider for working with Microsoft SQL Server Compact without installing additional components.
You may load and save data using the SaveToDB add-in.
Why does the Microsoft Excel Refresh menu not work for web data?
The SaveToDB add-in uses an internal provider with advanced features for working with web data.
Why do web-requests sometimes display wrong data?
The SaveToDB add-in uses smart algorithms for parsing table data from web pages in HTML, XML, and JSON formats.
If there are several tables on the page, then the most suitable one is chosen. Sometimes it can be the table of contents, which contains more "useful" data than the real table with data.
Try to use pages for printing which contain fewer formatting tables.
If a web page is not parsed correctly, you may send us a request. We will try to change the algorithms.
Why are user passwords saved unencrypted?
SaveToDB uses standard Microsoft Excel features for working with databases. Microsoft Excel saves the passwords unencrypted.
You may encrypt the entire workbook or even the disk drive to prevent using your password by other people.
SaveToDB allows using workbook personally at all as other users can connect the data using their credentials.
SaveToDB uses an internal provider for working with web data.
For web data, user's sensitive information is encrypted using Windows encryption features.
Microsoft Excel cannot connect to Oracle. What is the problem?
If connection data is correct and the server is available, see Fixing Oracle Database 10g Connection Error.
Why do I have to reenter the password to have access to web data?
The possible reasons are:
the password is changed,
or the workbook is opened under another user account,
or the login credentials have expired.
Why does the query list show native, not translated, names for all database objects?
The translation must be configured in a database, and the appropriate data language should be selected in the Options dialog box.
Why does the query list show native, not translated, names for some database objects?
If several objects have the same name after translation, then the first name is displayed translated, and the others are displayed with the native database names.
All translated object names should be unique.
Why is the Publish Wizard disabled?
The wizard works with Excel tables early named "Lists". Any table cell must be selected.
See Publish Wizard for a complete description.
In short, select the desired table range and click Excel "Insert, Table" to insert an Excel table.
SaveToDB tab has disappeared. What should I do?
Select File, Options and activate the Add-ins tab.
If the SaveToDB add-in is in the Inactive Application Add-ins group, then select COM Add-ins in the Manage combo box and the Go... button.
Then select the SaveToDB and click OK.
If the SaveToDB add-in is in the Disabled Application Add-ins group, then select Disabled Items in the Manage combo box and the Go... button.
Then select the SaveToDB and click the Enable button.
I cannot install the SaveToDB add-in. What to do?
The most probable reason is that you try to install the add-in from the path containing some national specific characters.
Try to create a folder named in English and to install it from this folder.
Why are the Views group buttons disabled?
The add-in works with Excel tables early called as Lists.
A possible reason is that your sheet does not contain any table.
To insert an Excel table, select a table region and execute the Excel Insert, Table command.
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.