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