David Emerson
davide at dalyn.co.nz
Wed Mar 17 20:09:04 CST 2004
Solved - Problem seemed to be trying to import when the spreadsheet was open in Excel. Close it and the dates import as dates. David At 18/03/2004, you wrote: >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 > >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com >