[AccessD] Import Date from Excel

David Emerson davide at dalyn.co.nz
Wed Mar 17 17:41:41 CST 2004


I have a spreadsheet in Excel that is imported into a SQL2000 
table.  Because the field types are unknown the SQL fields are varchar(200).

The problem is with dates - excel shows a date as 2/1/2004 but in the SQL 
table it is imported as 38018.

I am using VBA to deal with each row at a time.  How do I convert the 
number (38018) into a date?

Regards

David Emerson
Dalyn Software Ltd
25 Cunliffe St, Churton Park
Wellington, New Zealand
Ph/Fax (877) 456-1205 




More information about the AccessD mailing list