|
ATTENTION! You can insert data,
update data in the Excel table but you CANNOT DELETE data from a table in the
Excel file.
This topic describes step by step instructions you should
follow in order to correctly insert data into a table in the Excel file.
1. Click Database Manager
in the program's main window, click the black down arrow and then click
Add New menu.
2. Type any Action Name,
for example, Excel. Select Action Type -
Insert into table and click
Select Database Button.
3. Select your database. Click Next.
4. Check Use connection
string checkbox. Click Build
button.
5. Select Excel Files
that contain your database. Click New
button.
6. Select your database. Click OK.
7. The Connection string
will be automatically filled in. Click OK.
8. You will see the fields from your table in Excel in the
first column. You have to assign to these fields the appropriate values, i.e.
values extracted by Field Extractor. To do this, click the right mouse button on
the selected string and select the appropriate value for your field from the
popup menu. To assign your own value (which is not listed in the menu) to a
field, select Custom Value and type your
text.
|
