|
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 -----
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.
-----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.
----- Original Message -----
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
|
