Install Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb)
Conversion of the file format from XLSX to XLSB
A file conversion is just a change of the file that was created in one program (XLSX file) to a form intelligible for another program (i.e. XLSB format). There are many websites offering file conversion of XLSX to XLSB files 'Online' - without having to download a special program to your computer. However, if you have not found the appropriate XLSX file converter in the Internet, you can use our list of programs to cope with the conversion of the XLSX to XLSB file.
My C# code is working for an excel file and is reading all lines but for another file it is reading only first row and first column. Connection String: sConnStr1 = 'Driver={Microsoft Excel Driver. The older file extension xls and newer xlsx, xlsm, xlsb, pdf and xps are all explicitly covered Excel file extension xls, xlsx, xlsm, xlsb, xps, pdf Home Sample Files e-Books Books Wholesale Forums & Support Contact.
Conversion from XLSX to XLSB
XLSX to XLSB
How to convert the XLSX file to XLSB?
If you have already downloaded one of the converters and installed it on your computer, you can proceed to the appropriate conversion process of XLSX to XLSB. Handling all the programs is usually very intuitive and is based on the same pattern of conduct. We will briefly discuss a few steps that you always need to go through while changing the format of the XLSX file:
- Please indicate on your computer the source file XLSX, the format of which you are going to change
- Load the XLSX file to the application
- Select the output format of the XLSB file (the one that we want to achieve)
- Select the location to save the output file XLSB on the disk (the place where the program will save the converted file)
- Confirm conversion
- Wait for a moment
- Enjoy the converted XLSB file that can be found in the location selected in step 4
I cannot see the file extensions. What should I do?
File extensions are not normally displayed to users. To change this, go to Control Panel, select Appearance and Personalization and Folder Options. Next, select the View and find the option 'Hide extensions for known file types'. The option should be deselected (cleared) and confirmed with OK.
I'm having a problem with the ODBC connection that is supposed to connect to an Excel table and do stuff with it. I've already read a lot stuff on the internet about it, but none of the solutions helped me (including stackoverflow).
So basically I am at a point where I'm trying to open a connection to a table.
When I call the excel.Open() method, I get OdbcException with message:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified', which is odd because I have those specified in the string named con.
It's also worth to mention that in the ODBC Data Source Administrator, I can clearly see that I have those drivers installed and running.
There is also another odd part. When I call the following method I found on stackoverflow it returns me the following list of drivers:
- 'Driver da Microsoft para arquivos texto (*.txt; *.csv)'
- 'Driver do Microsoft Access (*.mdb)'
- 'Driver do Microsoft dBase (*.dbf)'
- 'Driver do Microsoft Excel(*.xls)'
- 'Driver do Microsoft Paradox (*.db )'
- 'Microsoft Access Driver (*.mdb)'
- 'Microsoft Access-Treiber (*.mdb)'
- 'Microsoft dBase Driver (*.dbf)'
- 'Microsoft dBase-Treiber (*.dbf)'
- 'Microsoft Excel Driver (*.xls)'
- 'Microsoft Excel-Treiber (*.xls)'
- 'Microsoft ODBC for Oracle'
- 'Microsoft Paradox Driver (*.db )'
- 'Microsoft Paradox-Treiber (*.db )'
- 'Microsoft Text Driver (.txt;.csv)'
- 'Microsoft Text-Treiber (*.txt; *.csv)'
- 'SQL Server'
- 'SQL Server Native Client 11.0'
None of those have the '*.xlsx' in them, which is the format of a file I'm trying to read.
The method is the following:
It should be noted that when I actually go to the regedit and find those values I clearly see:
Am I missing something obvious? Please help me :)
Install Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb)
By the way I'm pretty new to this side of .NET so please keep your answers dumbed-down so I could actually understand what is going on. Thank you!
EDIT:A friend pointed out I should give more information, so here is the screenshot of the regedit, ODBC Data Source Administrator and the proof that the ACEODBC.DLL actually exists on my hard drive:
Also the con.ToString() gives the following:
3 Answers
How about using OleDbConnection, and you have to install Microsoft Access Database Engine 2010 at first.
I Looks like your application is a x86 (32bit) application and you are looking at the 64 bit ODBC driver. Check if the 32bit ODBC driver is installed....
Make sure you have downloaded and installed the Microsoft Access Database Engine 2010 Redistributable....
And change your connection string to...