Hi all,

if anyone can help with this it would be a appreciated..
i have built a generic system that uploads information
from excel spreadsheets using ODBC and ASP.

for the first excel sheet i used, everything worked fine,
uploaded the data, happy.

the next sheet i used had a lot more columns, (about 78)
and I get the following error when I try and read it:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[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.
/metacalc/default.asp, line 364

HERE is the code:

Set ExcelRecordSet = Server.CreateObject("ADODB.Recordset")
ExcelRecordSet.ActiveConnection = ExcelConn
ExcelRecordSet.CursorType = 3 'Static
cursor.
ExcelRecordSet.LockType = 2 'Pessimistic
Lock.
ExcelRecordSet.Source = "Select * from calculator"
ExcelRecordSet.Open



364 ExcelRecordSet.MoveNext


so you can see that the error is on the MoveNext, so it has opened it
successfully, but can't move thru the rows..
If I delete rows from the spreadsheet it works ok..
I have tried to find out why there is this limitation in ODBC
or whether its my fault.
Is there some way to increase the size that it can handle?


any help would be most appreciated..

thanks,

steve