| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 599.1 | I think Access does it for you | NSIC00::KLERK | M/S: ERB01 / 2.15 DTN 7843-8644 | Wed Mar 16 1994 07:52 | 10 |
| 599.2 | Thanks for the tip - it worked perfectly | RDGENG::snowpc.reo.dec.com::Snowling | | Fri Mar 18 1994 17:47 | 7 |
| 599.3 | | BUSY::SLAB | Erotic Nightmares | Mon Dec 30 1996 17:13 | 10 |
| 599.4 | Still the same answer | NSIC00::KLERK | Thunderbirds are Go | Mon Dec 30 1996 19:39 | 16 |
| 599.5 | | BUSY::SLAB | Good Heavens,Commander,what DID you do? | Tue Dec 31 1996 13:15 | 10 |
| 599.6 | | BUSY::SLAB | Erin go braghless | Thu Mar 06 1997 19:19 | 10 |
|
How about importing an XLS file with a MM/DD/YYYY field?
Somewhere between Excel and Access, my dates were all changed to
some sort of Julian format, and Access can't seem to convert them
back to dates.
Do I have to go back to the Excel spreadsheet and change the form-
at to DD-MMM-YYYY in order for it to work correctly?
|
| 599.7 | | BUSY::SLAB | Good Heavens,Commander,what DID you do? | Fri Mar 07 1997 15:57 | 5 |
|
Well, it appears that all I had to do was remove the 3 title lines
from rows 1-3 of the Excel spreadsheet, and the date column loaded
just fine. I don't even think the date format really matters now.
|