PureBasic Forums - English

Hello everyone,

I have a program that export data to an excel spreadsheet using the ODBC library in PureBasic. Most of the code comes from:

viewtopic.php?t=6072&highlight=excel+odbc

I just have one little problem. I export numbers, and they are not recognized as a string. Do you know how to specify the format in the SQL query string?

Thanks,
Thank God It's Friday!
Tony

I also forgot to mention that:
http://www.crystalsoftware.com.au/datap ... _odbc.html

Excel Cells default to a General form, which means that if it sees something that looks like a number, it treat it like a number, and if it looks like a date, it will treat it like a date, and so on.

I suspect that you need to select the column that you want to have treated like a string and tell Excel to treat everything as a Text. Then it will not try to convert it into something else.