IMHO, RODBC should only be used if you have an Excel file without holes, and
with very regular numeric data. I don't understand why the online
documentation is not updated to give a usage note that RODBC will often fail
reading Excel files.
should be modified to have a warning "RODBC considered harmful with Excel
"Keith Sabol" <sabolk at hotmail.com> wrote in message
news:BAY114-F12CBDEDD885260F9BE1AA7D75C0 at phx.gbl...
I am using the RODBC package to read data from an Excel file.
My problem appears to be related to specification of data types by column.