Hi Jeff,

I opened it in Excel and found the data trimmed.

But, in notepad, it appears fine.

So, I guess to open a CSV file in Excel and look at the...

Hi,

I have the same issue.

With a single tick(quote), using DTS, it retains the tick as well.

eg., '0123 in database turns out '0123 in csv file.

But, in Excel, a tick(quote) then...