ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MS Query import from Excel - Syntax Error (https://www.excelbanter.com/excel-discussion-misc-queries/82412-ms-query-import-excel-syntax-error.html)

EstherJ

MS Query import from Excel - Syntax Error
 
I am setting up a MS query linking it to a Excel spreadsheet which contains
the named range of Database. I go through the wizard choosing my fields and
when I click on Finish it gives me an error message saying "Syntax error in
FROM clause". The help feature does not give any explanation, so any ideas
would be welcome.

Thanks,

Esther

sean_f_howard

MS Query import from Excel - Syntax Error
 

The problem is the range name Database, check out the article at

http://support.microsoft.com/default...171899#EDAGAAA


--
sean_f_howard


------------------------------------------------------------------------
sean_f_howard's Profile: http://www.excelforum.com/member.php...o&userid=30953
View this thread: http://www.excelforum.com/showthread...hreadid=531465



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com