Exporting to Excel and Apostrophies

[John]

Hi All,
I am using the following function to output data to an excel (.xls) file via
a dataset, listview, etc...

Dim m_sConn1 As String = ""
m_sConn1 = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & FileName$ & ";Extended Properties=""Excel
8.0;HDR=YES"""
Dim conn As New OleDbConnection

I am INSERTing the data into the file.
All works wonderfully; but every cell has an Apostrophe in the beginning of
the cells value. I understand that this is representing a TEXT data type;
but it messes things up when trying to sort by dates or numbers.

Does anyone have any idea as to the resolution for this?

Thanks,
John.

 

[William Ryan eMVP]

John:

Are you using a Strongly Typed Dataset? If not, are you specifying the
column data types in your untyped dataset?

--

W.G. Ryan, eMVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

 

[Jamie Collins]

...

John:

Are you using a Strongly Typed Dataset? If not, are you specifying the
column data types in your untyped dataset?

Is the OP even a dataset?! I understood he was excuting INERT INTO
statements against the Jet Provider.

Jamie.

--

 

[John Rugo]

The Data Type for each column is "Text"

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

 

[John Rugo]

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!