Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tool bar: Data/Import external data/New database query | Setting up and Configuration of Excel | |||
Importing Data via Database Query | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
when importing data from external database does not load into wor. | Excel Discussion (Misc queries) | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) |