PC Review Forums Newsgroups Microsoft DotNet Microsoft Dot NET Framework Forms Reading Data from Excel with all column filled gives error

Reply

Reading Data from Excel with all column filled gives error

 
Thread Tools Rate Thread
Old 19-06-2008, 11:50 AM   #1
Neeraj
Guest
 
Posts: n/a
Default Reading Data from Excel with all column filled gives error


Hi,
I am using ADO.NET. And JET 4.0 provider to read the data form
excel 8.0. Excel 8.0 have column limit as 255.
means A1 to IV. But when i fill all column with data including last IV
and try to read then it gives error that
"Too long field defined."All my cell have one or two character
record. But if i delete the last column IV record then it works
properly. can you give me information why it is happening.

Thanks
Neeraj Kumar
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off