External table not in expected format

Posted by Oswaldlily under ASP.NET on 5/21/2019 | Points: 10 | Views : 245 | Status : [Member] | Replies : 2
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;"




Responses

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

Up
0
Down
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

Posted by: Sunnysunny on: 6/10/2019 [Member] Starter | Points: 25

Up
0
Down
I regularly visit your site and find a lot of interesting information.
Not only good posts but also great comments.
Thank you and look forward to your page growing stronger.
https://wuxiaworld.live

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response