View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Terry Mulvany Terry Mulvany is offline
external usenet poster
 
Posts: 1
Default Excel OLEDB format problem...

Hi,
I have .NET code that uses Microsoft.Jet.OLEDB.4.0 to create Excel
worksheets of data. The end result is that we get an Excel Worksheet with
columns (both header and individual rows) that have alpha-numeric data
prefixed by a single quote (').

When I open a blank worksheet and enter data in this manner (prefaced by a
single quote) it appears that this is a symbol to tells Excel to 'format
numbers as text'.
Does anyone know how to insert data into Excel sheets via OLEDB such that
data is NOT prefaced with these single quotes?

Note: The table (sheet) is being created via standard CREATE TABLE and the
columns are of type char(100) or char(255).

Thank you.