Need help in excel/mssql

05/25/2012 04:00 CraYu#1
Hey guys so I try to import Characterdata.txt and ItemData.txt to the right tables but for some reason my excel makes weird values and notepad show them correct :S like datetime or this

[Only registered and activated users can see links. Click Here To Register...]

And the points need to be replaced with commas with find and replace it don't work :(

Edit: Finished it with Open Office Calc :)
05/25/2012 05:44 PortalDark#2
have you tried to make Text to columns and use "," as separator, then copy and paste(mssql and notepad get different columns as [TAB])