Does anyone know why when I'm using ADO to read the Excel file and if the column in Excel file is numeric, it returns nulls? It works fine for Text column. Is this a bug in ADO?
Printable View
Does anyone know why when I'm using ADO to read the Excel file and if the column in Excel file is numeric, it returns nulls? It works fine for Text column. Is this a bug in ADO?
Try this
'*******First U have to go to the project references and '******select the object library 9.0 or 8.0
Option Explicit
Dim xlsApp As Excel.Application
Private Sub Command1_Click()
Set xlsApp = Excel.Application
With xlsApp
'Show Excel
.Visible = True
'Create a new workbook
.Workbooks.Add
'Put text in to the cell that is selected
.ActiveCell.Value = "Hi"
'Put text into A3 regardless of the selected cell
.Range("A3").Value = "This is an example of connecting to Excel"
'************
I don't want to use Excel Object. That why I use ADO.
Bear in mind ADO is still a work in progress...
Is this a bug in Microsoft ADO? If it is a bug with ADO, why don't they fix it or this is some sort of marketing scheme where in order for you to access Excel file you must have Excel installed. Does anyone know where I can get to the ADO site and read or post some messages? Thanks!
Does anyone has any ideas?