Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import external data New database quearry
Dear all,
I am trying to import data from the quearry from access. But after pressing finish button of quearry wizard, the message appeares... "Syntex error in FORM Clause. Do i need to set any other way to import quearry from ms access or quearry cannot be imported! ( which is not possible to believ ). Any help in this regard will help me lot. -- Dhimant |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import external data New database quearry
Try performing the same query using access instead of excel. There may be an
error in the database. "Dhimant" wrote: Dear all, I am trying to import data from the quearry from access. But after pressing finish button of quearry wizard, the message appeares... "Syntex error in FORM Clause. Do i need to set any other way to import quearry from ms access or quearry cannot be imported! ( which is not possible to believ ). Any help in this regard will help me lot. -- Dhimant |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import external data New database quearry
Hi Joel,
Thanks for reply. But i tried at my office pc and at my home also. Same answer is recd. Is it possible that the table used for the quearry are link table? -- Dhimant "Joel" wrote: Try performing the same query using access instead of excel. There may be an error in the database. "Dhimant" wrote: Dear all, I am trying to import data from the quearry from access. But after pressing finish button of quearry wizard, the message appeares... "Syntex error in FORM Clause. Do i need to set any other way to import quearry from ms access or quearry cannot be imported! ( which is not possible to believ ). Any help in this regard will help me lot. -- Dhimant |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import external data New database quearry
If the query is working in access, then there probably an incompatiblity in
versions of exc el verses accesss. You may want to look at the SQL statement that is generated in excel to see if you can locate the problem. On the last menu of the Query wizard in Excel there is an option to edit the query. Look at the SQL statements to see if there is anything that may be causing a problem. "Dhimant" wrote: Hi Joel, Thanks for reply. But i tried at my office pc and at my home also. Same answer is recd. Is it possible that the table used for the quearry are link table? -- Dhimant "Joel" wrote: Try performing the same query using access instead of excel. There may be an error in the database. "Dhimant" wrote: Dear all, I am trying to import data from the quearry from access. But after pressing finish button of quearry wizard, the message appeares... "Syntex error in FORM Clause. Do i need to set any other way to import quearry from ms access or quearry cannot be imported! ( which is not possible to believ ). Any help in this regard will help me lot. -- Dhimant |
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 | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Import External Data: Saving changes to the database | Excel Discussion (Misc queries) | |||
PLEASE!! How can I un-grey the 'Data-Import External Data-Import Data' option ??? | Excel Programming | |||
Extractind data from external database | Excel Programming |