data transfert = OVERFLOW

data transfert = OVERFLOW

Post by Marianne Novell » Thu, 21 Feb 2002 04:08:56



Hello,

Everytime I'm triing to transfert data from Access 97 to
SQL serv 7, I have the  error message OVERFLOW. I've tried
to import from SQL, but I always have an error of
caractere with some tables... those problem tables, I do
an append query on Sql, but I have the Message OVERFLOW...

What can I do to solve this problem....

Thanks a lot
Marianne

 
 
 

data transfert = OVERFLOW

Post by Simon Liao[M » Fri, 22 Feb 2002 12:06:10


Hi Marianne

Here are some articles may help you:

Q165827 UT97: "Overflow" or "Division by Zero" Error Upsizing Table
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q165827

Q301672 ACC97: Overflow or #Div/0! Err Executing Query, Form or Report
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q301672

Q279454 Acc97 : "Overflow" Message When Upsizing to SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q279454

Regards,

--- Simon Liao

This posting is provided "AS IS" with no warranties, and confers no rights.

 
 
 

data transfert = OVERFLOW

Post by Marianne Novell » Fri, 22 Feb 2002 23:24:01


Tank you verry much, the UT97 is the best... it's my
advice, but I can't find Wzcs97.mda file we have to
oppen... By hazard, you don't know where to find it... I
know the site is giving us a place, but I don't find it....

Marianne

Quote:>-----Original Message-----
>Hi Marianne

>Here are some articles may help you:

>Q165827 UT97: "Overflow" or "Division by Zero" Error
Upsizing Table
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q165827

>Q301672 ACC97: Overflow or #Div/0! Err Executing Query,
Form or Report
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q301672

>Q279454 Acc97 : "Overflow" Message When Upsizing to SQL
Server 2000
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q279454

>Regards,

>--- Simon Liao

>This posting is provided "AS IS" with no warranties, and
confers no rights.

>.

 
 
 

data transfert = OVERFLOW

Post by Marianne Novell » Sat, 23 Feb 2002 00:51:43


OK Simon... I've finnally found it... tank's again....
Quote:>-----Original Message-----
>Hi Marianne

>Here are some articles may help you:

>Q165827 UT97: "Overflow" or "Division by Zero" Error
Upsizing Table
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q165827

>Q301672 ACC97: Overflow or #Div/0! Err Executing Query,
Form or Report
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q301672

>Q279454 Acc97 : "Overflow" Message When Upsizing to SQL
Server 2000
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q279454

>Regards,

>--- Simon Liao

>This posting is provided "AS IS" with no warranties, and
confers no rights.

>.

 
 
 

1. transfert of data

Hello,

I wish to transfer from went back to a data base on another servertowards a
base bearing the same name (the names for the basic units ofdata are
different).

The bases were both created with same scripts.However, the units of data
bases do not have the same size.

That of the server of destination is larger than that of the server source.
I have errors by carrying out the transfer between the two servers.

How to carry out this transfer of dated without problem.

I want just to transfer dated them.

Thank you

Christophe Lafille

2. suppress field via text file in FoxPro

3. Transfert Data to SQLServer

4. Sql New Record Identity

5. transfert of data

6. IF EXISTS error??

7. Excel to Paradox data transfert

8. US-MD-ORACLE DBA

9. Data Overflow error in Data transfer from Access to SQl Server

10. Can DTS transform fixed width data that overflow?

11. Arithmetic overflow error converting numeric to data type numeric

12. Data types.......Cast binary to integer WITHOUT overflow......

13. Arithmetic overflow error converting expression to data type int