LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Order of columns in Workbook Connections

I am using a workbook connection to pull data from a sql source into a
worksheet. Is there any way to define what order the columns are ordered in
the resulting array? I'd like to be able to put my primary key in the
leftmost column ("A") so I can lokup data using that key in a VLOOKUP
function.

Thanks!
--
Adam Aronson

FullCity Consulting Inc.
Certified FileMaker Developer
Platinum FileMaker Business Alliance Members
2007 FileMaker Partner of The Year
 
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
how do you put columns in alphabetical order by last name amyupton Excel Discussion (Misc queries) 2 June 2nd 08 11:27 PM
Printing Columns (not A,B,C order) weezy Excel Discussion (Misc queries) 2 June 15th 06 06:56 PM
in order of columns ceemo Excel Discussion (Misc queries) 1 April 19th 06 10:20 PM
Workbook date order Monty New Users to Excel 1 September 30th 05 06:48 PM
How 2 reverse order of columns Bill Meacham Excel Discussion (Misc queries) 3 February 20th 05 03:29 AM


All times are GMT +1. The time now is 01:30 AM.

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"