David Emerson
davide at dalyn.co.nz
Wed Mar 17 18:25:06 CST 2004
A further piece of info - I can't set the SQL field to datetime as it rejects the number as not being a date when it is imported. David At 18/03/2004, you wrote: >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 >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com >