Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bokazoit
Starting Member
6 Posts |
 Posted - 2008-02-01 : 09:26:36
|
| In SQL express I can save a query result as a csv file. And that works nicely. But here is the problem. I send the file to a server that reads ; - seperated files, but it fails to read the file. The only solution is to open it excel and then save it again as a csv file. Then it works without any problem.Have You seen this problem before? I wouldn't expect a microsoft product having difficulties to generate a working csv file :pany suggestion to solutions?In advance tx ;-) |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-01 : 09:37:47
|
| Have you tried Exporting the file with a specific delimiter , and then seeing if you can IMPORT on the other server ?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
Bokazoit
Starting Member
6 Posts |
Posted - 2008-02-01 : 09:44:23
|
| Ohh the server is not on my hands. I have to send it delimited with ; |
|
|
|
|
|
|
Export to CSV strange problem