Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data via an external database query
I'm guessing here.
PMC_VAR_MELT_INFORMATION is a table in the Access database where you wrote (and executed) the original query. I suspect the problem is that Excel has no idea where to find this table. -- Ian -- "rtiguy" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data via an external database query
PMC_VAR_MELT_INFORMATION is an external Oracle table. In Excel I use the same
ODBC data source that I use in Access to connect to the Oracle database so it can find the table. A simple select query on this table using Excel works correctly. "IanC" wrote: I'm guessing here. PMC_VAR_MELT_INFORMATION is a table in the Access database where you wrote (and executed) the original query. I suspect the problem is that Excel has no idea where to find this table. -- Ian -- "rtiguy" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data via an external database query
Like I said, I was guessing.
Hopefully someone else can help you with this. -- Ian -- "rtiguy" wrote in message ... PMC_VAR_MELT_INFORMATION is an external Oracle table. In Excel I use the same ODBC data source that I use in Access to connect to the Oracle database so it can find the table. A simple select query on this table using Excel works correctly. "IanC" wrote: I'm guessing here. PMC_VAR_MELT_INFORMATION is a table in the Access database where you wrote (and executed) the original query. I suspect the problem is that Excel has no idea where to find this table. -- Ian -- "rtiguy" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |