ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using ADO to query CSV with no unpredictable headings (https://www.excelbanter.com/excel-programming/407533-using-ado-query-csv-no-unpredictable-headings.html)

todtown

Using ADO to query CSV with no unpredictable headings
 
My query only works if there are headings. However, the files I am
connecting sometimes have headings, sometimes don't. Even if the
heading is only a space I can work with it. But no heading and I get
the no value given for one ore more requirements error.

I need to insert headings or get around this problem somehow.

tod


All times are GMT +1. The time now is 11:22 AM.

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