Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Access 2.0 , SQL Loader

Access 2.0 , SQL Loader

From: <kif_at_worldnet.att.net>
Date: 1997/09/13
Message-ID: <5veq58$346@bgtnsc03.worldnet.att.net>#1/1

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 Received on Sat Sep 13 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US