[RBG7-L] - Re: Importing Excel data

[gary.wend]

Karen, you might want to check and see how the file is saved.  If it is saved as a worksheet vs a workbook.  The workbook works better than the worksheet in passing through date information.  You might also use the csv file format.  This is my choice of method.  It eliminates trying to remember how I saved the workbook/sheet.   In using the csv format, I automated  the loading process via a  command file.  It is much faster than going through Gateway.   Gary ----- Original Message ----- From: [EMAIL PROTECTED] To: RBG7-L Mailing List Sent: Friday, October 28, 2005 2:09 PM Subject: [RBG7-L] - Importing Excel data Using version 7.1 Trying to import an Excel spreadsheet that has one date column in it.  When in Excel I look at Format Cells of the column, it shows DATE  mm/dd/yy. My database settings are Format mm/dd/yy,  Sequence mmddyy. When my table has a date column, this comes in as blank. When I make the column text, it comes in with what I assume is a julian number.  10/14/03 came in as 37908, 10/15/03 as 37909, etc. What am I missing?  How can I get the dates to load in, or if I can't how do I turn the Julian date into a regular date? Karen