This file was created in a previous beta version of Excel 2007 Open the file with Excel 2007 to save it to the most recent version of the Excel 2007 file format before opening the file in Access 2007

News Knowledge Base
, ,
1

This file was created in a previous beta version of Excel 2007. Open the file with Excel 2007 to save it to the most recent version of the Excel 2007 file format before opening the file in Access 2007.

Issue Description:

With the help of Write range activity, after adding 2 or more columns to the Excel file and then when trying to update the column values with the help of “Execute Non Query” activity it updates the record correctly for one row but after that an error is generated post which the file also cannot be opened as it gets corrupted.

Error Message:
This file was created in a previous beta version of Excel 2007. Open the file with Excel 2007 to save it to the most recent version of the Excel 2007 file format before opening the file in Access 2007.

Resolution:
Instead of using Excel as a DB(Execute Non-query) Execute Non query, suggested to use a Powershell script to update the required Excel columns instead of us

PS Script:

<$fileName = "C:\Users\{user}\Downloads\May_2022_BTISBDX.xlsx"
$provider = "Provider=Microsoft.ACE.OLEDB.12.0"
$dataSource = "Data Source = $fileName"
$extend = "Extended Properties=Excel 12.0"
$ddlSQL = "update [Sheet1$] set Status='done' where ([Bond #]=123456234)"

$conn = New-Object System.Data.OleDb.OleDbConnection("$provider;$dataSource;$extend")

$sqlCommand = New-Object System.Data.OleDb.OleDbCommand
$sqlCommand.Connection = $conn
$conn.open()

$sqlCommand.CommandText = $ddlSQL
$sqlCommand.ExecuteNonQuery()
$conn.close()
>

Also suggested to pass the required parameters as String instead of Data row as it would make the query complex.