External table not in expected format

Posted by Oswaldlily under ASP.NET on 5/21/2019 | Points: 10 | Views : 2399 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

HI Team,

a)
While connecting with excel, I'm using below connection string. But it giving as error "Extrenal table is not in the expected format". Kindly help me to resolve

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 12.0;HDR=Yes;ReadOnly=0;"

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Jayakumars on: 5/31/2019 [Member] [MVP] Bronze | Points: 25

0	hi check your connection and excel driver file installed in your pc or not checking them why you use excel you can use database thats best practice for datamanupulation Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts