I'm using oleDB in VB.NET to read database from Excel.
In Excel I have 2 columns datatype: DATE. 1st column contain usual date, 2nd column contain Arabic date (take value exactly from 1st column).

In VB, I have DataGridView to display table from Excel.
This is my coding:
|
This is the result:

Now, my questions:
1. How can I show Arabic date format in column 'Adate' without change any format in Excel?
2. What is data type I must assign to retrieve Arabic date format for "CREATE TABLE", in case I want to store it in database (MySQL)?
- I tried using DATE, CHAR, NCHAR, VARCHAR, TEXT, but it make no change..
TQ.
Suthish NairPosted Mar 5, 2011, 10:27 AM
IMEX=1; ==> will read all the cell data as text value.
refer: http://www.connectionstrings.com/excel
Akv SeijiPosted Feb 16, 2011, 1:24 AM