SQL query into an excel file ignores cells with dashes


  • We have some software that allows us to parse an excel spreadsheet as a database, which then formats the information onto printable labels. In the spreadsheet, there is a column of numbers (each number being between 3 and 6 digits long). Each of those numbers are successfully placed onto the labels except for about 3 of those numbers that happen to have 5 digits, a dash, and then another digit (XXXXX-X). This causes the software to not successfully read those particular cells, consequently, leave the area of the label (where those numbers should be placed) blank. Seeing that the software utilizes SQL to select the information from the spreadsheet, is there a query element that allows us to include data that includes a dash in the cell?

    I hope this makes sense. Let me know if you have any thoughts on this.

    Thank you,


    Monday, July 08, 2013 6:00 PM


All replies