Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exports to csv formats
Message
From
04/04/2012 05:47:42
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01540229
Message ID:
01540231
Views:
37
>>Hi
>>
>>I'm extracting some data from SQL and sending it out as a csv file.
>>
>>Some of the data is address data and some of the addresses (this seems peculiar to Scottish addresses for some reason ) have lines like 1/1. I assume these are flats in blocks.
>>
>>When the csv is opened this gets displayed as a date.
>>
>>Any thoughts on the best way to stop this happening.
>>
>>Thanks
>>
>>Nick
>
>Put some string before it.

Would a space do it ?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform