[RBG7-L] - Re: Importing Excel data

[Gunnar Ekblad]

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: rbg7-l@rbase.com [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