Ken,
I would check the formatting in Excel. I really haven't noticed any of my clients who import excel spreadsheets on a regular basis ever having anything but normal date formatting. Steve Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 From: [email protected] [mailto:[email protected]] On Behalf Of Ken Shapiro Sent: Monday, December 20, 2010 4: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
