Re: excel to 400 transfer

["Bill Meecham" <bmeecham@xxxxxxxxxxxxxxxxxxxx>]

This is a guess but an L type requires a null value of 0001-01-01.  Could it
be that the transfer is not loading that value for the default null value?

Bill


----- Original Message -----
From: Lawrence Roberts <robertslaw@hotmail.com>
To: <MIDRANGE-L@midrange.com>
Sent: Tuesday, October 31, 2000 1:22 PM
Subject: excel to 400 transfer


> Having a problem sending an Excel file up to the '400. The transfer
request
> is failing with an SQL errid of 0180, invalid date or timestamp. The
> spreadsheet field is defined as an Excel date format and the '400 field is
> an "L" type date definition. Any help would be appreciated.
>
> Thanks all.
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---