View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John Rugo John Rugo is offline
external usenet poster
 
Posts: 2
Default Exporting to Excel and Apostrophies

The Source of the Data being exported to the file is in a variety of
forms.

DataSet
ListView
DataGrid
Etc...

The point is, regardless, I create the column structure and then the
Insert Into statement for each row. Everything works great with the
exception of the apostrophy bing created in the begining of each cell of
the file.

The only way to remove this apostropy is via another procedure/program
that loops through and removes this special character(by excel
standards).



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!