I get the following message when running the program:Įrror: SQLException - : Invalid precision value Well, I straigthened out the "no suitable driver issue" but now have a different problem. make sure that this is a space between "MicroSoft Access Driver" and "(*.mdb)"ĪConnection = DriverManager.getConnection("jdbc:odbc:Driver= RE: Export Access Database To Excel File JDOne (Programmer) ("FileNotFoundException " + fnfe) Ĭlass.forName("") ("Finshed creating a sheet1 within the workbook") Sheet1 = wb.createSheet("Data From AccessDB") Creating a new sheet1 inside the workbook ("Created Excel Workbook: "+ excelFileName) String excelFileName = "C:\\SampleAccessToExcel.xls" įileOut = new FileOutputStream(excelFileName) Excel will open the file and create the columns itself. If you prefer a easier way, create a csv file from the results and give the ".csv" ext to the file. This is just a sample of what you can do.
Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) there is this small note that states: The new OLE DB provider is called the Microsoft OLE DB Driver for SQL Server.
#ODBC EXCEL DRIVER INVALID USE OF NULL DRIVERS#
To use the sample code below.download the POI API, add the jar file to your classpath. Take your time and read the information about the Different generations of OLE DB Drivers on the web page. Here is an example using the POI API ( to take the data from the result set and put them into a excel sheet.