Re: excel to 400 transfer

[rob@xxxxxxxxx]

Can you sample this with a spreadsheet of one row of data?  Basically to
see if you have an invalid date somewhere in the spreadsheet.

If that still fails, and you just know that your spreadsheet is right,
then, how about coming from the opposite direction?  Key in some sample
data into the file on the 400 and download it into Excel?  Just to test how
it works.


Rob Berendt

==================
Remember the Cole!


                                                                                
                                         
                    "Lawrence Roberts"                                          
                                         
                    <robertslaw@hotmail        To:     MIDRANGE-L@midrange.com  
                                         
                    .com>                      cc:                              
                                         
                    Sent by:                   Subject:     excel to 400 
transfer                                        
                    owner-midrange-l@mi                                         
                                         
                    drange.com                                                  
                                         
                                                                                
                                         
                                                                                
                                         
                    10/31/00 01:22 PM                                           
                                         
                    Please respond to                                           
                                         
                    MIDRANGE-L                                                  
                                         
                                                                                
                                         
                                                                                
                                         




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
+---