Wrox Programmer Forums
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 17th, 2008, 12:15 AM
Authorized User
Join Date: Jan 2006
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error reading data from excel to sql using ASP


I am trying to load data from excel to SQL. The program was working fine. Now its throwing an error
[Microsoft][ODBC Excel Driver] The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

I have changed the data field size in SQL, but still this error exists.I am sure its nothing to do with SQL.
Could some one please help me, iz this the error with Excel. Do i have to explicitly mention the buffer size for excel or is it the problem with the connection string.
Pls Help

Thanks in Advance.

Old June 17th, 2008, 12:40 AM
Friend of Wrox
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts

It's a curious error message. It *READS* like you are trying to write data to Excel, not just read from it.

First thing to try is to just *STOP* doing any WRITEs to the SQL Server DB, at all. Just do reads from Excel and see if the problem still persists.

And if it does, then for starters, I'd try narrowing down just *which* field is causing the problem.

But I don't see how we can help you debug code when we can't see the code. So if you don't figure it out, maybe you should post the code? At least the seemingly relevant parts?

Similar Threads
Thread Thread Starter Forum Replies Last Post
problem in reading excel data premnaath ASP.NET 2.0 Professional 5 October 22nd, 2007 10:14 AM
access data of excel sheet into sql server in asp KGANESH2006 SQL Server ASP 2 April 20th, 2006 02:33 AM
data reading from excel using VB belzicool VB Databases Basics 3 December 22nd, 2005 06:28 AM
reading data from excel sheet rajiv_software Classic ASP Basics 2 April 30th, 2005 01:03 AM
Saving Excel data to SQL Server via ASP sankar Classic ASP Databases 6 February 11th, 2005 09:22 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.