Could not open XLSX file exported using oLedb

See more:

VB

Hi,

I am saving sample data table from database to Excel using OLEDB connection.

If I save the excel file with [.XLS] extension, I can open the file and see the stored data table.

But if I create the Excel file with [.XLSX] format, after moving datatable,
if I try to open it I am getting error like
"File format or file extension is incorrect. Check whether file has corrupted or file extension doesnot match with file format" and I cannot open the Excel file.

I am using Windows 7 and tried installing "Acess Database engine" but still getting the same error.

Below is the src code in which I am trying to create simple excel file with .XLSX format.
(File path selected is C:\\Users\Vijay\Desktop\Recipe.XLSX)

Dim saveDialog As New System.Windows.Forms.SaveFileDialog
        saveDialog.Title = "ExportFile"
        saveDialog.Filter = "MS Office Excel2007|*.xlsx"
        'saveDialog.DefaultExt = "xlsx"
        'saveDialog.SupportMultiDottedExtensions = True
        saveDialog.FileName = "Recipe"

        If saveDialog.ShowDialog() = Windows.Forms.DialogResult.OK Then

            ExpFileName = saveDialog.FileName
        End If

        Dim ConString As String = ""

    ConString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=""Excel 12.0;HDR=YES"";Data Source={0}", ExpFileName)
        Dim conObj As New System.Data.OleDb.OleDbConnection()
        conObj.ConnectionString = ConString
        conObj.Open()


        Dim createTable As String = "CREATE TABLE sheet1(VJ1 char(255),VJ2 char(255))"

        Dim cmd As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand(createTable, conObj)

        cmd.ExecuteNonQuery()

Thanks in Advance,

Vijay