Export to Excel and Single Quote problems?

  • Thread starter Thread starter John Rugo
  • Start date Start date
J

John Rugo

Hi All,
I am exporting data from a dataset to an excel spreadsheet via OLEDB.
Everything works fine but one part.

All my cells have a single quote in the beginning of each piece of data. I
realize this is how Excel maintains the data as text; but I am wondering how
I can prevent this from happening at all.

Thanks,
John.
 
¤ Hi All,
¤ I am exporting data from a dataset to an excel spreadsheet via OLEDB.
¤ Everything works fine but one part.
¤
¤ All my cells have a single quote in the beginning of each piece of data. I
¤ realize this is how Excel maintains the data as text; but I am wondering how
¤ I can prevent this from happening at all.

I'm not aware of any way to handle this on import. Unfortunately it's a function of the driver.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top