LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Importing data via an external database query

The following query works fine using Access:

SELECT PMC_VAR_MELT_INFORMATION.ARC_STRIKE_TIME,
PMC_VAR_MELT_INFORMATION.COOL_STOP_TIME
FROM ((PMC_VAR_HEAT_INFORMATION INNER JOIN PMC_VAR_ELECTRODE_INFORMATION ON
PMC_VAR_HEAT_INFORMATION.HEAT_ID = PMC_VAR_ELECTRODE_INFORMATION.HEAT_ID)
INNER JOIN PMC_VAR_MELT_INFORMATION ON
PMC_VAR_ELECTRODE_INFORMATION.ELECTRODE_ID =
PMC_VAR_MELT_INFORMATION.ELECTRODE_ID) INNER JOIN [Electrode first and last
melt ID] ON PMC_VAR_MELT_INFORMATION.MELT_ID = [Electrode first and last melt
ID].Melt_ID
WHERE ((("8"+Mid$([PMC_VAR_HEAT_INFORMATION.HEAT_NUMBER],2,1))=85))
ORDER BY PMC_VAR_MELT_INFORMATION.ARC_STRIKE_TIME;

If I try to create the same query in Excel by copying the SQL statement from
Access, Excel displays the message: Could not add table
'((PMC_VAR_HEAT_INFORMATION'

Is this statement too complex for an Excel query?

Any suggestions would be appreciated.

Thanks.
 
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
Tool bar: Data/Import external data/New database query Daniel Setting up and Configuration of Excel 3 February 28th 08 08:40 AM
Importing Data via Database Query Franklin Smith Excel Discussion (Misc queries) 0 October 17th 07 05:37 PM
database query not showing foxpro database How I import data mangat New Users to Excel 1 June 24th 07 03:31 PM
when importing data from external database does not load into wor. Hari[_2_] Excel Discussion (Misc queries) 0 March 19th 07 03:52 PM
Importing Data via Web Query - Can values be passed to query? [email protected] Excel Discussion (Misc queries) 5 May 9th 06 06:21 PM


All times are GMT +1. The time now is 09:14 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"