ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using OleDB to get data from Excel (https://www.excelbanter.com/excel-discussion-misc-queries/750-re-using-oledb-get-data-excel.html)

dvd00
Using OleDB to get data from Excel
 
Hi Jamie! You wrote in message

What happens when you remove

;IMEX=1;

from the connection string?

Jamie.

--

Nothing - the situation is the same.

Jamie Collins
(dvd00) wrote ...

Hi Jamie! You wrote in message

What happens when you remove

;IMEX=1;

from the connection string?

Jamie.

--

Nothing - the situation is the same.

The reason I asked was that I tested using the data and process as you
described in your original post: I could reproduce the results when
using IMEX=1 in the connection string but when I removed it the
results came out as desired and expected.

I would be happy to re-test if you re-post the data and cell formats
you are using.

Jamie.

--


All times are GMT +1. The time now is 04:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com