Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing OLEDB drivers in Excel 2000 (9.0.28.12) | Excel Discussion (Misc queries) | |||
Using OleDB to get data from Excel | Excel Discussion (Misc queries) | |||
OLEDB Help Excel 2002 | Excel Programming | |||
EXCEL AND OLEDB | Excel Programming | |||
Excel schema using Jet OLEDB Provider? | Excel Programming |