255 Character limit when opening URL's, any way around it?

  • Thread starter Mike T - EHT, NJ
  • Start date
M

Mike T - EHT, NJ

Any way to get around the 255 character limit in a File->Open URL or External
Data Query?

I don't have any control over the length of the URL (which happens to be 257
characters). Does 2007 have this same problem?

Here is my URL breakdown, if someone can test this out for me:
format, 7 character: "http://"
server, 25 character: "intranet_svr.company.com/"
path, 5 character: "path/"
filename, 12 character: "csvlist.cgi?"
querypart, 208 characters:
"columnlist=field1,field2,field3,field4,...&"
"field1=somevalue,field2=...&"
"outputtype=csv"

Amazing how quickly those characters can get used up, but they do.

Any way to configure the filename limit?
 
M

Mike T - EHT, NJ

For clarification, I'm using Excel 2003 now (sp3).

Can anyone confirm that 2007 isn't affected? My previous version wasn't,
but since I just got a new PC with 2003 on it, I don't know which version I
had.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Any way to get around the 240-character line limit on text output? 3
255 character limit 4
How can I change 255 character limit in 'hyperlink' function? 0
Sql Query: 255 character Limit 2
SQL 255 Limit workarround?? 6
255 Character Limit for Linked Excel data 1
Concatenate - 255 character limit 5
Remove 255 character limit from OLE DB .NET and Fix Data Corruptio 1

Top