Is the field in Excel with the dates actually formatted as a date field? Or is it formatted as a number with dashes?
I am trying to figure what you meant by as stored as numbers with a fraction. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Ken Shapiro Sent: Monday, December 20, 2010 5:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Question On Gateway Import Using Excel Hello All, Using the Gateway Import command against an Excel spreadsheet, I am not able to import date fields successfully, against R:BASE 9.1. I don't remember ever trying to import a date field from an spreadsheet and can't find any information in the help about it. Dates in Excel as stored as numbers with a fraction. When trying to import the column from the spreadsheet into a table it goes into a date column as null. Any helpful suggestions? Regards, Ken
