[RBG7-L] - Re: Importing Excel data - problem loading dates

[Gunnar Ekblad]

Karen did you really tried the ODBC approach?   Gunnar Ekblad   -----Ursprungligt meddelande----- Från: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] För [EMAIL PROTECTED] Skickat: den 31 oktober 2005 18:04 Till: RBG7-L Mailing List Ämne: [RBG7-L] - Re: Importing Excel data - problem loading dates   I wound up getting dates into my table by saving the Excel spreadsheet as a .csv file.  That's really disappointing because it means that the client (not me) is the one that has to always bring the spreadsheet up and then resave it.  Hard to explain to the client that RBase will not bring in their spreadsheet dates any other way.  Believe me, I spent alot of unbillable hours trying to get those dates in there!  Even going manually through the wizard, where you're able to tell it what the dates look like, would display those weird integer numbers in the preview window yet bring blanks into the table. Thanks for all the suggestions.  I tried them all.  A simple old csv file is the way to go, but like I said it requires the client to resave their spreadsheet each time. Karen