Ken,
I did an xls import into a 9.1 test database for a client with DOB and an exam date and both columns came in fine. 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 5:34 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Question On Gateway Import Using Excel I think it's the spreadsheet. I created a new spreadsheet and entered a bunch of dates in the first column and was able to import it successfully. Now to figure out what the issue is in the spreadsheet I'm testing with. Thanks for the help, I'll post back if I can figure out why the original spreadsheet is having an issue. Regards, Ken From: [email protected] [mailto:[email protected]] On Behalf Of Steve Vellella Sent: Monday, December 20, 2010 7:17 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Question On Gateway Import Using Excel Ken, Have you tried importing into a column that is formatted as a datetime column? 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 5:09 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Question On Gateway Import Using Excel Steve: The format on the spreadsheet was changed to mm/dd/yyyy. Jim: Unless the date is entered as a string, meaning ="06/01/2010"; dates are stored internally as a whole number plus fraction. The fraction represents times. You can see this if you set the format to General. AS I said above the formatting was set to: mm/dd/yyyy. Regards, Ken From: [email protected] [mailto:[email protected]] On Behalf Of Steve Vellella Sent: Monday, December 20, 2010 6:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Question On Gateway Import Using Excel 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
