|
For MS Excel files, additional steps involve selecting the spreadsheet and worksheet. Sage EasyPay can connect directly to a MS Excel file and there isn't a need to create an ODBC connection or set up a DSN under the ODBC Data Source Administrator. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
Shows the identity of the spreadsheet. This is the primary key for the ImportSpreadSheet table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Stores any remarks about the spreadsheet. |
|
Name |
|
|
Code |
|
|
Data Type |
char(200) |
|
Mandatory |
No |
|
Displays the file path of the spreadsheet. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the type of file for the spreadsheet. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
Shows the password for the file. |
|
|
|