ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Import external data (https://www.excelbanter.com/excel-discussion-misc-queries/173806-import-external-data.html)

juanpablo

Import external data
 
Hi,

I need to import some data that varies each day, and the data collected is
inserted each day in a different sheet.

Is it possible to use the Import external data so I can do it automatically.

The source site to import the data is:

http://www.aipchile.cl/ifis/consulta...escompleto.php
then, each day and for the dropd down list SCEL, I need to import the data.

Thanks!

Raymond_Angana via OfficeKB.com

Import external data
 
Hi juanpablo,
You could import it by Data | Import External Data | New Web Query
Then on the address bar, key-in the source of your data. See if it helps.

juanpablo wrote:
Hi,

I need to import some data that varies each day, and the data collected is
inserted each day in a different sheet.

Is it possible to use the Import external data so I can do it automatically.

The source site to import the data is:

http://www.aipchile.cl/ifis/consulta...escompleto.php
then, each day and for the dropd down list SCEL, I need to import the data.

Thanks!


--
"This isn't good or bad. It's just the way of things. Nothing stays the same.
" Real live preacher.

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200801/1



All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com