What's the trick???

[total_newbie!]

When I create an excel file and save it as a csv to upload to my sql server it isn't formatted right. Anyone know of a tool I can use to make uploading easier?? Easypopuplate isn't working because I have big images mod installed and can't seem to figure out what the problem is.

 

Thanks

[Ashley]

Hi!

 

Sounds like the problem might be when the file is actually being saved. Are you sure it is saving it without automatically modifying it? What version of Excel do you use?

 

~Ashley

[total_newbie!]

I'm using Office XP. I save it as a .csv and it adds the comma's but not the single quotes ('). In fact, I can see the single quotes when I click on the cell but when I save it as .csv the first single quote is not there. What do you use to upload files?