HomeActive Query BuilderExcel 2007 and quotes on Excel

Excel 2007 and quotes on Excel


Hey,
two questions about Excel :

Is Excel 2007 connection available to load in AQB Active X Edition?

Why a simple query to Excel 2kx source is changed when is loaded in AQB?
ActiveQueryBuiderX1.sql='Select F1,F2 from [Datos$]' after this sentence
AQB has this sql= 'Select F1,F2 from Datos$' , Why the characters '[]' disappear?

thanks
Francesc | email
April 11 2009, 05:57 PM
Please check that your SQLSyntax property is set to xsMSAccess2003 value.
Sergey Smagin | email
1 day, 8 hours since original post
This topic is closed