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

[KarenTellef]

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