Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > THE workaround for the Excel > 256 characters issue

Thread Tools

THE workaround for the Excel > 256 characters issue

Posts: n/a
Fellow members,

I have read tons of content on the issue that ASP can not read Excel
spreadsheet columns having more than 256 characters. I think I've read
them all ...

Here's what I do:
strExcelDocName = "c:\test.xls"
With cnnExcel
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=" & strExcelDocName & ";" & _
"Extended Properties=""Excel 8.0;IMEX=1;"""
End With

Set rstExcel = Server.CreateObject("ADODB.Recordset")

sTableName = "[sheet1$]"
sTableName = "select * from " & sTableName & ";"

rstExcel.Open sTableName, cnnExcel, _
adOpenStatic, adLockPessimistic

Do While Not rstExcel.EOF
myString = rstExcel.Fields.Item(0).Value


By now, the experts among us have already detected that 'my_string'
won't store values exceeding 256 characters.

If any one you has found / developed ANY workaround (or alternative) I
would be very much obliged ...

Thanks in advance.


Reply With Quote

Thread Tools

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How many characters to make Winzip AES 256 unbreakable? Zak Computer Security 24 07-14-2008 02:14 AM
256 + 256 = 384 !!??! Ike Computer Support 23 05-26-2006 06:56 PM
How Many VarBinary for each Ascii Char Aes Encrypted KeySize=256,BlockSize=256 Phil C. ASP .Net Security 3 02-25-2005 04:28 PM
TRADE 256 Compact Flash and Reader for 256 SD Jim Spencer Digital Photography 3 10-10-2003 09:51 PM
Calloc of "unsigned char my_bytes[256][256]" M-One C Programming 43 07-16-2003 09:47 PM