the maExpireDate field is in DD/MM/YY format, whereas the rest of
the fields are in MM/DD/YY format. You need to fix that date format
issue before the import will be successfull.
> ----- Original Message -----
> From: Jean Gionet <overboard@cyberbeach.net>
> To: <emerald@iea-software.com>
> Sent: Tuesday, October 12, 1999 9:39 AM
> Subject: Re: [Emerald] import into emerald 2.5
>
> > Hi Peter,
> >
> > I checked the PROPERTIES of the Conversion table and this is what I have:
> > Column Name DataType Size
> > PaidThru datetime 8
> > BilledThru smalldatetime 4
> >
> > I used the 22convert.sql script on our active SQL 6.5 server.
> >
> > Here are the URL's for some snapshots of the Import Util and the SQL
> INSERT
> > error.
> > http://home.cyberbeach.net/emerald/importsnap-1.gif (Verify Import)
> > http://home.cyberbeach.net/emerald/importsnap-2.gif (Do Import)
> > http://home.cyberbeach.net/emerald/importsnap-3.gif (SQL INSERT ERROR)
> >
> >
> > Thanks
> > -Jean
> >
> >
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
> >
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart
