Huge web query - takes up more than 256 cols

05-13-2004, 08:14 AM

Enforce

Freshman

Join Date: Jun 2003

Location: Israel

Posts: 33

Huge web query - takes up more than 256 cols

Hi all!
I'll get to the point..
I have a web query that takes up more than the default 256 columns per sheet and I can't seem to find how to query a bigger table without losing some of the columns.. any ideas?

THX!!

05-13-2004, 08:51 AM

Mike Rosenblum Mike Rosenblum is offline

Microsoft Excel MVP

Forum Leader
* Guru *

Join Date: Jul 2003

Location: New York, NY, USA

Posts: 7,848

Yes... break up your Query to have a maximum of 256 fields. Then do one Query per Worksheet. So "one" Query will effectively span more than one worksheet (possibly many). Probably should bring in the Key Unique ID in each case just so that you can more easily keep the data synchronized.

Keep in mind that there is also a Row limitation at 65,536 rows...

-- Mike

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Database Query ----Please Advise-------	broadcast28	Database and Reporting	1	03-21-2004 09:54 PM
Huge SQL Query problem	VeRiTo	Database and Reporting	3	01-08-2004 01:00 PM
SQL Statement issues in an MS Query	MDodd73	Excel	3	11-03-2003 09:32 AM
Network SQL Application	m4cc4	Database and Reporting	7	08-27-2003 08:37 AM
How to compare an empty value in a query..	pragash	Database and Reporting	1	10-22-2001 11:12 PM