jdy0803
Well-known member
I try opening Excel file using OleDbConnection like following.
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.
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?
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.
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?