Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OleDb connection to Excel - date converted to string
Message
From
11/07/2007 09:43:45
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
All
General information
Forum:
ASP.NET
Category:
ADO.NET
Title:
OleDb connection to Excel - date converted to string
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Network:
Windows 2003 Server
Miscellaneous
Thread ID:
01239233
Message ID:
01239233
Views:
70
I have an application that reads a date (formatted as Date) from an Excel file using an OleDb connection into an untyped dataset. This has been working fine, but suddenly when the date I was trying to read became 7/13/2007, the value in my dataset turned to String type of "39275". When I change the data format type in Excel to string, it becomes "39275", so that is where that value came from. How can I fix this so it loads as a date instead of a string?
Very fitting: http://xkcd.com/386/
Next
Reply
Map
View

Click here to load this message in the networking platform