ADO Excel SQL UPDATE changes cell format?
I have successfully connected with ADO and JET Engine to an Excel workbook
and everything (well nearly everything) works fine.
But after I made a change in my program (not at all related to my ADO code)
an ADOCommand.Commandstring:
UPDATE Fakturering SET Fakturert = '2008-04-24' WHERE Fakturering.Fakturert
IS NULL
changes not only the value in this cell but also the font name in that cell
from Arial to Helv?
When I browse the drop-down list of available fonts I can't even find "helv"
in that list!
Can somebody enlighten me what on earth is going on here? (And preferably
how I can avoid any change in the format settings)
(BTW: After I made the change in my program I also suddenly had to enclose
the date (2008-04-24) within quotes, apparently because for some reason
something started applying arithmetic on the figures in the date.)
regards Sven
.
Relevant Pages
- Re: Ron de Bruins code "Copy a range from all files in a folder and subfolders (optional)" ???
... In a Database you cannot mix data types, a column must be all numbers or all text. ... are different data types in the column ADO will copy only the Data type that have the majority. ... If you want to copy only one cell from each workbook then use A3:A3 and not A3 in the code. ... Dim sh As Worksheet, destrange As Range, destrange2 As Range, destrange3 As Range ...
(microsoft.public.excel.programming) - Re: Ron de Bruins code "Copy a range from all files in a folder and subfolders (optional)" ???
... In a Database you cannot mix data types, a column must be all numbers or all text. ... are different data types in the column ADO will copy only the Data type that have the majority. ... If you want to copy only one cell from each workbook then use A3:A3 and not A3 in the code. ... Dim sh As Worksheet, destrange As Range, destrange2 As Range, destrange3 As Range ...
(microsoft.public.excel.programming) - Re: Data Mix in ADO recordset column.
... > I am pulling out data from excel thorugh ADO recordset object. ... If even one cell in that column contains ... > cell contents in that column have correct numeric data. ...
(microsoft.public.data.ado) - Re: ADODB.Recordset from workbooks : numbers only?
... ADO is basically treating you Excel sheet as a table in a database. ... , formula and cell references have no meaning, only the result in each cell. ... Set rsData = New ADODB.Recordset ...
(microsoft.public.excel.programming) - reading Excel data via vbscript & ado
... I have worked out how to read a single excel cell with a ... without opening and closing the ado recordset multiple times. ... all this does is read a single cell and display the value in a message ...
(microsoft.public.scripting.vbscript) |
|
