kAREN, The "37908" you are finding is the internalformat that Excel stores dates. It is an integer balance that represents the number of days from same base date.
You need to format in Excel as a date for it to be readable Jim Bentley American Celiac Society --- [EMAIL PROTECTED] wrote: > I should clarify, the only problem I have found is > when a worksheet is saved in xl3 version. The > loading of data would not carry the date regardless > of what I did. The date column in the table would > look exactly like the data you have stated in your > email. In loading the data manually, the only work > around I was able to implement was save the data as > a workbook and use Gateway to import the data. > Otherwise, I would save as a CSV file and use the > load command. > > The key..... using CSV or Gunnar's recommendation of > ODBC eliminates the hassle of what version and how > do I save. > ----- Original Message ----- > From: Gunnar Ekblad > To: RBG7-L Mailing List > Sent: Saturday, October 29, 2005 8:26 AM > Subject: [RBG7-L] - Re: Importing Excel data > > > Gay and Karen > > I would add importing to an existing table I think > worksheet works better, but importing to a new table > workbook works better. > > An other approach is to set up the Excel as an > ODBC that I find best for tasks that shall be > repeated many times. > > > > Gunnar Ekblad > > > > -----Ursprungligt meddelande----- > Från: [email protected] [mailto:[EMAIL PROTECTED] > För [EMAIL PROTECTED] > Skickat: den 29 oktober 2005 03:15 > Till: RBG7-L Mailing List > Ämne: [RBG7-L] - Re: Importing Excel data > > > > 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 > Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 __________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com
