Odbc excel driver external table is not in expected formatHi team,.
I'm trying to connect with excel for inserting rows...
We are getting issue as " external table is not in expected format".
We have Microsoft office 2013 32 bit and extension used is .xlsx
Strexcel= "Provider=Microsoft.Ace.oledb.12.0;Data source=excel path.xlsx;extended properties="Excel 12.0;hdr=Yes;";"
Using this connection string.. we have template in shared drive.. then we are copying from this template and pasting into new path and renaming the file(just appending dates) and doing the insert process...
Kindly do the needful