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. |
All times are GMT +1. The time now is 08:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com