Karen
The
gateway command I sent you is what I use in 6.5++
In
7.1 Help it does not seem to have the date1 option.
So if it does not work
try droping the date1 option.
Rod Holly
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, October 28, 2005
3:10 PM
To: RBG7-L Mailing List
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
