ODBC default value

Question

In my excel sheet I have 10 Date values in a column continuously. 11,12 and 13th row has 8 digit number values in the same column. Those number values are shown in '#' marks because I've formatted the entire column as Date.

When I export excel data to Visual Fox-Pro DBF table using ODBC connector it comes the 11th row value as a long date like 11/06/7719. 12 and 13th row values are empty.

My question is why is the 11th row value converts from Number value to Date value. Actually it also should be empty as 12 and 13th row values.

Please someone help.

Answer 1

More specifically, Excel can interpret numbers up to 2958465 as dates but larger not.  So 2125657 converts to 11/06/7719 but numbers >=2958466 can't.

---

If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire

Answer 2

Thanks Shane,

These are the values in 11th to 13th rows.

26062001, 27062010, 28062010

If this is the case how can I avoid these conversion, otherwise it imports wrong date values.

Answer 3

Most likely the number in the 11 row can be intrepreted as a date by Fox Pro but the two other number are outside of For Pro's date range.

We would need to know the actual values in rows 11-13 to answer.

---

If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire