Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I am familiar with web query and it's working fine for me in most cases. However, one of the tables i'm importing from daily is changing it's format back and forth all the time which in turn creates inconsistency in my imports (data swithes columns in my spreadsheet). I've tried changing some options with the query but to no avail. Good news though. The exact same data is available in a .csv file at the same website. Problem is that I have only worked with web query on html pages with tables and have no idea on how to import a csv file automatically and separate it into columns. Any help with this would be much appreciated. /Mitch |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
import data with macro | Excel Discussion (Misc queries) | |||
import data using macro | Excel Discussion (Misc queries) |