Velocity Reviews - Computer Hardware Reviews

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

Reply
Thread Tools

THE workaround for the Excel > 256 characters issue

 
 
JV
Guest
Posts: n/a
 
      03-22-2005
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;"""
.Open
End With

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

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

rstExcel.Open sTableName, cnnExcel, _
adOpenStatic, adLockPessimistic

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

rstExcel.MoveNext
loop

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.

JV

 
Reply With Quote
 
 
 
Reply

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



Advertisments