topic Defining field from Access database as text in QlikView https://community.qlik.com/t5/QlikView/Defining-field-from-Access-database-as-text/m-p/469027#M1158894 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #1f497d;">One of my QlikView applications pulls data from an Access Database.&nbsp; Access has a field as a text field, but when the data goes to QlikView it seems to convert some of the codes to numbers while leaving the ones beginning with a letter as text.&nbsp; What can I do so that QlikView considers all entries for this field as text?&nbsp; I tried modifying my load statement the way I’d do it if this was an Excel file.</SPAN></P><P style="text-indent: 0.5in;"><SPAN style="color: #1f497d;">Text(Header_Diagnosis_Code_Primary) as [Primary Diagnosis Code]</SPAN></P><P><SPAN style="color: #1f497d;">However, QlikView didn’t recognize the Text command as part of this load statement like it did in the load statements for my Excel files.</SPAN></P><P></P><P><SPAN style="color: #1f497d;">Any help will be appreciated!</SPAN></P></BODY></HTML> Thu, 27 Dec 2012 19:29:27 GMT 2012-12-27T19:29:27Z Defining field from Access database as text https://community.qlik.com/t5/QlikView/Defining-field-from-Access-database-as-text/m-p/469027#M1158894 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #1f497d;">One of my QlikView applications pulls data from an Access Database.&nbsp; Access has a field as a text field, but when the data goes to QlikView it seems to convert some of the codes to numbers while leaving the ones beginning with a letter as text.&nbsp; What can I do so that QlikView considers all entries for this field as text?&nbsp; I tried modifying my load statement the way I’d do it if this was an Excel file.</SPAN></P><P style="text-indent: 0.5in;"><SPAN style="color: #1f497d;">Text(Header_Diagnosis_Code_Primary) as [Primary Diagnosis Code]</SPAN></P><P><SPAN style="color: #1f497d;">However, QlikView didn’t recognize the Text command as part of this load statement like it did in the load statements for my Excel files.</SPAN></P><P></P><P><SPAN style="color: #1f497d;">Any help will be appreciated!</SPAN></P></BODY></HTML> Thu, 27 Dec 2012 19:29:27 GMT https://community.qlik.com/t5/QlikView/Defining-field-from-Access-database-as-text/m-p/469027#M1158894 2012-12-27T19:29:27Z