That said, if you need to view all the data at once, you need to open the form results in Excel. The form is great in terms of collecting responses.So, validating or performing a lookup against a smaller table will be faster than against a larger table. Answer / Solution: When Kofax Capture / Ascent Capture connects to a table for Database Validation, it retrieves the entire table contents.If it's any use, the connection string is: Dsn=Spiceworks database=\\MyServer\db\spiceworks_prod.db stepapi=0 notxn=0 shortnames=0 longnames=0 nocreat=0 nowchar=0 fksupport=0 oemcp=0 I did read in another post a reported issue with slow response time displaying all the Spiceworks tables, but I do not believe this to be the case here as the 'expanding' message does not appear.We often use a two file approach when developing with live connections. What you would want to do is add the excel data into the original data source that is supporting the live connection. There is not a method at this time to conduct a data mash up data between Live Connection and other sources.The workbooks are all saved locally on my PC, so it’s not a network issue. Visually, what I see on the bottom right corner is that it is “Connecting to Datasource…” for the entire time, once that shifts everything else completes rapidly.
