I'm not looking for instructions on how to pull data from Excel. I already know two ways to do that. I'd like opinions on which way is better.
Currently I'm using ADODB to create a recordset representing Excel data. It has it's caveats: namely ADO will guess at the data type (defaults to numeric) and treat anything of a different type as Null. For the most part I can survive this limitation (I think).
I also know that I can use the Excel object library to pull data. It'll get rid of the typing problem but it may introduce other problems (not really sure about this). If I write my app using excel 11 will it work properly if the end user only has excel 10 (or earlier)? I'm afraid that using the object library may impose compatibility issues.
Summary, which is worse: Having to lose data in some cells because of ADO limitations? Or possibly not being able to read any cells because of compatibility issues?
Are there actual compatibility issues or am I mixing up excel with every other MS product that has versioning problems?
Currently I'm using ADODB to create a recordset representing Excel data. It has it's caveats: namely ADO will guess at the data type (defaults to numeric) and treat anything of a different type as Null. For the most part I can survive this limitation (I think).
I also know that I can use the Excel object library to pull data. It'll get rid of the typing problem but it may introduce other problems (not really sure about this). If I write my app using excel 11 will it work properly if the end user only has excel 10 (or earlier)? I'm afraid that using the object library may impose compatibility issues.
Summary, which is worse: Having to lose data in some cells because of ADO limitations? Or possibly not being able to read any cells because of compatibility issues?
Are there actual compatibility issues or am I mixing up excel with every other MS product that has versioning problems?
