Excel 2003 Data Import - Web Query

M

MG

Hi,

In Excel 2002 - I think - I could execute a query using
data->import external data->web query with a url that looks
something like:

http://teamtrack/tmtrack/tmtrack.dl...ype=1&reporttype=1&RptKey=1110500391&Recno=-1

Now, however, when I try to do it everything is fine - the
webquery exectutes properly in the preview window - right
up until I say import. I then select the defaults
(existing worksheet a1) and click ok. The query pastes
into excel and then it comes up with an error:

The file could not be accessed. Try one of the following:

Make sure the specified folder exists
Make sure the folder that contains the file is not readonly
Make sure the filename does not contain any of the
following characters: < > ? [ ] : | or *
Make sure the file/path name doesn't contain more than 218
characters.

Now look at my url it does contain a ?... but it seems
really self-defeating to prevent a query string on a data
import from a url - doesn't it?

This seems like a bug but I have done my office 2003 update
and it still occurs. I have also verified that the exact
steps work in Excel 2002.

Where is the best place to file a bug report for this?

Thanks,

MG
 

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

Top