ODBC export to Excel Spreadsheet, how to force format

tony · Post by **tony** » Sat Jul 19, 2003 2:32 am

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

tony · Post by **tony** » Sat Jul 19, 2003 5:30 am

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

oldefoxx · Post by **oldefoxx** » Fri Jul 25, 2003 11:48 pm

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.