Importing CAD Data from Web

[djm]

I'm importing San Antonio FD CAD data from their "Active Fire Responses" Web site

http://epay.sanantonio.gov/activefir...=1024&ver=true

to an Excel file.

I'm refreshing the data every minute (this matches the refresh rate of the site).

With each refresh, I lose the data previously captured to the Excel file.

Anybody know how I can update the file AND preserve the old data?

Thanks.

[fmon]

I'm using Excel 07. I think you need to select a new Cell prior to update. I.e. Cell A6 etc.

Very nice feature this Excel Web Import.
Edit:

Incident	Status	Location	Description	Units Involved
7079229	A	972 HEDGESTONE 	        BRUSH, GRASS 	2
7079236	A	4815 RITA ST 	        MEDICAL RESPNS 	1
7079237	A	IH 10 W / LA CANT       MEDICAL RESPNS 	1
				
Incident	Status	Location	Description	Units Involved
7079229	A	972 HEDGESTONE 	        BRUSH, GRASS 	2
7079236	A	4815 RITA ST 	        MEDICAL RESPNS 	1
7079237	A	IH 10 W / LA CANT       MEDICAL RESPNS 	1
				
Incident	Status	Location	Description	Units Involved
7079229	A	972 HEDGESTONE 	        BRUSH, GRASS 	2
7079237	A	IH 10 W / LA CAN        MEDICAL RESPNS 	1
7079238	A	5341 GAWAIN ST 	        MEDICAL RESPNS 	1
7079239	A	7710 OAKDELL 	        UNAUTH BURNING 	1

[djm]

Frank, I see you were successful.

I'm using a 2003 version of Excel...can't get it to duplicate what you did. How did you specify the cell? Was it just a matter of selecting it on the spreadsheet itself, or was it part of a function or formula? I believe I'm missing something.

Thanks

[fmon]

Prior to updating, I clicked into Cell A6 - giving me a blank line between earlier listing - then re-click From Web. You will need to navigate back to the source web page, highlight new data and select Import.

[djm]

Thanks for the tip. But I was hoping for a way to copy all the traffic over several hours, without manual intervention. I don't have MS Access, I wonder if that's what I need to do this.