G
Gavin Taylor
Hi, I’m a first timer on the forum.
I am using Excel Web queries to accesses some Tables. However the tables consist of far more Rows of information than I would like to accesses.
I know that web queries can be edited in as text in note pad. I am trying to limit the query by Date Range, for instance I wish to view only entries dated for the precious month. Below is an example of the .qry file viewed in note pad.
I have also included a row data from the table.
Note Pad
WEB
1
http://etalk/cq/all_active_members.asp
Selection=AllTables
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
Table example
First Name, Last Name, Code, Email Address, Last Activity, Date Hired
Jeff Smith 0000 (e-mail address removed) 1/13/2003 10/13/2003
Any Help?
I am using Excel Web queries to accesses some Tables. However the tables consist of far more Rows of information than I would like to accesses.
I know that web queries can be edited in as text in note pad. I am trying to limit the query by Date Range, for instance I wish to view only entries dated for the precious month. Below is an example of the .qry file viewed in note pad.
I have also included a row data from the table.
Note Pad
WEB
1
http://etalk/cq/all_active_members.asp
Selection=AllTables
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
Table example
First Name, Last Name, Code, Email Address, Last Activity, Date Hired
Jeff Smith 0000 (e-mail address removed) 1/13/2003 10/13/2003
Any Help?