G
Guest
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
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