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
- [RBG7-L] - Importing Excel data KarenTellef
- [RBG7-L] - Re: Importing Excel data gary.wend
- [RBG7-L] - Re: Importing Excel data Gunnar Ekblad
- [RBG7-L] - Re: Importing Excel data gary.wend
