Need to update your databases? Spreadsheet Writeback provides you with the interface and tools to enable writing data from Microsoft® Excel workbooks to relational databases. Data may be written back to any table that has write privileges. You can create, delete, or modify one or more setups on each worksheet.
Benefits include:
- Pushes data from Excel to a database table
- Wizard-based Writeback setup
- Automatically determines whether records should be updated or inserted
- Data validation
- Multiple Writeback setups per sheet
Minimum software requirements
Spreadsheet Writeback
Minimum Software |
Recommended |
| Windows XP SP3 |
Windows 7 (32-bit or 64-bit) |
| Excel 2003 |
Excel 2010 (32 bit only) |
| IBM iSeries Access for Windows V5R1* |
IBM iSeries Access for Windows V5R2 or higher |
| Microsoft .Net Framework 4.0 |
|
| Microsoft Visual Studio 2010 Tools for Office |
|
* if using the iSeries