ODBC xlsx driver connectionstring without header. Obviously it's because of the parameter 'HDR=YES' but I cant figure out how to disable the header line. Zeta function calculator. I have tried 'HDR=NO' and leaving this parameter out but no effect. I can access to the file but I always lose the first line.
- Install Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb) Download
- Install Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb)
Install Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb) Download
31 Oct 2008 14:13 Tonci Grgin Hi Andy and thanks for your report. If something's critical, please take time to search bugsdb for solution and provide as much info as you can. With info provided so far, I can only guess. O c/ODBC 5.0 is discontinued, please use 5.1 instead o If you're on Vista x64 and you're using older MyODBC driver (don't see versions.) is is possible that you do not see driver in CP.
Install Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb)
Reason is that we used to have only 32bit versions of MyODBC (as all of the clients were 32bit and there is actually no use of 64bit driver but to stop reports like this). In this case you need to start 32bit ODBC driver manager instead of 64bit one you see in CP.