Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mitch
 
Posts: n/a
Default Having trouble with web query, importing not consistent.

Hi,

I have a nice book set up with web querys and it's doing a fantastic job for
me, except for one little problem:

The data does not always get imported to exact same place in the sheet, I'll
clarify.

The first column is supposed to contain a name, while the next 10 columns is
supposed to contain data after running a web update. That's the ideal
situation every time, and i'm updating once a day.

Now the problem is that somedays the data is imported in a different way.
For instance the name which is supposed to end up in the A column gets split
up so it now takes up the two first columns instead of just the first (A) and
this relays to all the other data which now ends up in the wrong column. I
don't know if this problem derives from the source, changing it's tables or
something else. Sometimes this issue won't arise for weeks then one day it's
there again and ruins my day...

Any help would be very appreciated.

Regards
Mitch
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Microsoft query data into excel changes linked rows Wazzy_bear Links and Linking in Excel 1 December 19th 05 09:09 AM
Importing data to Excel using MS Query John Excel Discussion (Misc queries) 1 November 17th 05 06:19 PM
AHHH! Again JAA149 Excel Discussion (Misc queries) 0 October 31st 05 11:36 AM
AHHHH-Get Data from Multiple Excel workbooks JAA149 Excel Discussion (Misc queries) 5 October 30th 05 05:19 PM
importing data from the query wizard jaxx Excel Discussion (Misc queries) 0 March 7th 05 09:51 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"