Hi,
I have downloaded personal edition and have started journey with Qlickview.
while accessing the dimension table from access database (.mdb file) , I am trying to create the select statement with the help of wizard by clicking the select button on data tab in the script editor.
I am able to connect to mdb file. as it has created connection string successfully.
OLEDB CONNECT32 TO [Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=D:\QlickviewDevelopement\AirlineOperations\DataFiles\DimensionTables.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False];
when i create the select statement using wizard it creates the statement as
LOAD `%Origin Airport ID`, `Origin Airport`;
SQL SELECT `%Origin Airport ID`, `Origin Airport`
FROM `Origin Airports`;
In the same create select statement wizard i am able to preview the data with the same column names.
But when I am trying to reload the data , it is giving me following error
Field not found - <%Origin Airport ID`,
`Origin Airport`>
SQL SELECT `%Origin Airport ID`,
`Origin Airport`
FROM `Origin Airports`
Can somebody help....
Regards
Santosh
