Error when open Excel file just in case regional date format is Bulgarian (Bulgaria)

jdy0803

Well-known member
Joined
Sep 9, 2012
Messages
73
Location
Santa Clarita
Programming Experience
10+
I try opening Excel file using OleDbConnection like following.


VB.NET:
cn = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0; Data Source=C:\Test.xls;Extended Properties = ""Excel 8.0;HDR=Yes""")
cn.Open()   '<===== here error occurs!
.
.
.



This works fine in English (United States) or other date format.
But, if I change date format to Bulgarian (Bulgaria), following error occurs at cn.Open.


error.png


Bulgaria uses simillar date format to Czech.
It works fine if I change date format to Czech but not Bulgaria.
I can't figure out this problem.
Can anybody give am some advice?
 
Back
Top