Hi,

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.
Soni

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?