Re: Access 2.0 , SQL Loader

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1997/09/15
Message-ID: <341d817c.14335946@netnews.worldnet.att.net>#1/1

You might be able to:

1. create a text field in the access table. make it a character field.
2. write an Access query to set that field to a character representation of the date.
3. Tell SQL*Loader to use the text field instead of the date/time field.

regards,

Jonathan

On Sat, 13 Sep 1997 19:50:36 GMT, kif_at_worldnet.att.net wrote:

>We have Oracle 7.3 on Win NT 4.0 and Access 2.0. When exporting Access table
>to text file, if it is a date/time field,Access exports the data with the
>timestamp even if the date format is short date. Because of this I get an
>error when I load it through SQL Loader. Is it possible to export the Access
>table to a text file without the timestamp for the date.
>
> Thanks

---

Jonathan Gennick
gennick_at_worldnet.att.net
"Brighten the Corner Where you Are" Received on Mon Sep 15 1997 - 00:00:00 CDT