Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error: ErrorSource: (null), ErrorMsg: (null) on load from access database

I've got a nice dashboard built pulling lots of data from an access database. Everything is working fine. Today I added a new table with some staffing information in it. If I run the query in the access database, all is well. Data shows up with correct values, no errors, etc. When I add it to the load script, it gives me a "Error: ErrorSource: (null), ErrorMsg: (null)" message and won't load that table. No idea what the issue is. The statement is:

SQL SELECT ChgNo,
Company,
dateserial(year(DataDate), month(DataDate), 1) as Monthly_DataDate,
Employee,
FTEs,
Location,
OT,
PED,
Position,
PositionID,
RateTableID,
ResID,
Source
FROM
`Master Staffing Database Format`;

Any ideas?

10 Replies
Not applicable
Author

Found the error. Apparently Position is a reserved word in either Qlikview or the OLEDB connection. Changing the field name (not aliasing it) allowed the data to load without issue.