Are there any Quantrix formulas that will not export to Excel?
The following formulas are specific to Quantrix functionality and will not export to an Excel spreadsheet. # isempty # between # clearerror # clearzero # dayofyear # err # first # join # last # s # select # selectbetween # selectgreaterthan # selectlessthan # selects I am getting a Too Few Parameters error message when connecting Quantrix to an Access database via DataLink. When trying to connect to Access stored queries that are unions of many external tables, any strings in the query need to be quoted with single quotes instead of double quotes. Once single quotes are used, the ODBC driver will be able to find the columns names and import the data successfully. Via DataLink, I can connect to an Excel file, but no tables or columns display. When connection to an Excel file with DataLink, users need to ‘name’ their ranges of Data in Excel in order for Quantrix to detect what data to access. In Excel, select the data you are looking to import and choose Insert > Name > Define to apply a
