...
Should be in .xlsx format
Needs to ‘look’ like a database table, i.e., simple rows and columns of data
Whilst it could contain totals and subtotals this isn’t a good idea as they would need to be identified and excluded, i.e., filtered, to stop the data doubling, or trebling up.
If your Excel file contains special characters, they will be replaced when the file is imported. Please see the following list for clarification of how your file might be changed:
Special Character | Replaced With |
|---|---|
- | _ (underscore) |
! (exclamation mark) | _ (underscore) |
& (ampersand) | _ (underscore) |
, (comma) | blank space |
; (semi colon) | blank space |
: (colon) | blank space |
' (apostrophe) | blank space |
/ (forward slash) | blank space |
( (open bracket) | blank space |
) (closed bracket) | blank space |
% (percent sign) | PERCENT |
In addition, the database user you have configured for this data connection will need to have been granted create and insert privileges, or equivalents, on the ‘target’ database.
...
| Info |
|---|
The Excel file needs to be accessible by the user that is running the Excel Reader process and by default the user, on Windows, is LOCAL SERVICE. |
If your Excel file contains special characters, they will be replaced when the file is imported. Please see the following list for clarification of how your file might be changed:
...
Special Character
...
Replaced With
...
-
...
_ (underscore)
...
! (exclamation mark)
...
_ (underscore)
...
& (ampersand)
...
_ (underscore)
...
, (comma)
...
blank space
...
; (semi colon)
...
blank space
...
: (colon)
...
blank space
...
' (apostrophe)
...
blank space
...
/ (forward slash)
...
blank space
...
( (open bracket)
...
blank space
...
) (closed bracket)
...
blank space
...
% (percent sign)
...