Posted to microsoft.public.excel.misc

RhysPieces RhysPieces is offline

external usenet poster

Posts: 18

Renaming columns in MS Query

I use several MS Queries to import into Excel '03 workbooks via ODBC from our
corporate mainframe (linked Access tables). I would like to rename the column
headings in the query design before returning the results to Excel. However,
despite the options to do so, I keep getting error messages about a 'missing
expected lexical'. I even tried editing the SQL statement but got the same
results. What's the trick to make MS Query rename the columns?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Database Query... can't see columns	willwonka	Excel Discussion (Misc queries)	0	August 30th 07 10:52 PM
Renaming Columns	Peter	Excel Discussion (Misc queries)	4	April 4th 06 07:12 AM
renaming columns	Timewalker	Excel Discussion (Misc queries)	2	February 10th 06 12:56 AM
Renaming Access Query used by Excel	UEUC2	Excel Discussion (Misc queries)	1	December 13th 05 05:19 PM
Excel, renaming columns	Treasuris	Excel Worksheet Functions	1	September 27th 05 02:03 AM

All times are GMT +1. The time now is 02:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us