HomeFlySpeed SQL QueryQuering EXCEL Spreadsheet

Quering EXCEL Spreadsheet


Getting following error:
Exception EOLeException in module FlySpeed SQL Query.exe at 00AC49B. Syntax error in FROM clause.

The query it is trying to execute is:
Select
Name$.*
From
Name$

Where Name$ is a sheet in the spreadsheet.
r | email
December 9 2010, 08:27 AM
This is the bug of the current version. To avoid it, open the Connection Properties dialog, click the More Options button, switch to the Advanced tab and set the "Quote all identifiers" option on.
Sergey Smagin | email
1 day, 23 hours since original post
This topic is closed