I want a imty solution...V.V.Imp. 
Author Message
 I want a imty solution...V.V.Imp.

Hello Friends,
   I want to solve a problem regarding the Download of
Excel data's to Access using VB (ADO Code).

During the Download of Excel data to Access,using ADO code
I am getting
Error : Run Time Error -2147467259(80004005) Numeric Field
Overflow

Actually this error , is due to the Default datatype
consideration of Excel.
(ie) Ado is Considering the Excel sheet as a Table and
While retreeving the data's from Excel. its Reading first
8 rows from sheeet and fixing the Datatype in default

So while reading that Excel Recordset

I am reaceving the Runtimeerror (as said above) because my
excel data for initial rows ie for first 100 rows is
number and then from 101 row is alfa numerinc. So if the
Default consideration of Excel data type is number then
its error for 101 th row

How to over come, if no way pl say the Efficient other
method to download the Excel datas to Access.

kumaran



Sat, 07 Aug 2004 20:00:55 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Newbie confused: VB6 vs VB.Net vs VBScript vs VBA

2. Access vs SQL Server vs Sybase vs Oracle

3. Newbie confused: VB6 vs VB.Net vs VBscript vs VBA

4. BMP Vs JPG Vs PictureBox Vs Resource file

5. Setup Programs: InstallShield vs PCInstall vs WISE vs...?

6. Adding xml file is not visible is VS.Net solution

7. Wanted VB 3.0 vs 4.0 info!

8. Jet 3.51 vs Jet 4.0 vs MSDE

9. Access97 vs. VS 6 SP2: cbbl()

10. Close vs Nothing + CurrentDB vs DBEngine

11. Data Type Usage: Single vs Currency vs Decimal

12. VS.NET 2003 project back to VS.NET 2002

 

 
Powered by phpBB® Forum Software