[RBG7-L] - Re: Import from Excel - extra info

[Gunnar Ekblad]

Karen I had the same problem. As soon I (in my case) changed the exceldate format to YYYY-MM-DD or in your case MM/DD/YYYY it worked nicely.     Gunnar Ekblad   -----Ursprungligt meddelande----- Från: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] För [EMAIL PROTECTED] Skickat: den 28 oktober 2005 21:29 Till: RBG7-L Mailing List Ämne: [RBG7-L] - Re: Import from Excel - extra info   That's what I did.  In my destination table, I made the column a TEXT type, thinking it would bring the date in, just looking like a text value, but that's when it brought it in with these integers.  Is that what you meant? I don't want to have the users bring the spreadsheet up and change the format there to something else. Karen Karen, one way to do this is to import the date as a text value, and convert later.