M
Maury Markowitz
I have a table with a lookup key in column 1, and a variety of data in other columns. One of these is empty, and I'm trying to populate it with data from a local DB.
I'm making up some SQL, using QueryTables.add, and returning the results into a cell in the empty column. All of this works fine - the data is being returned correctly.
However, it is also inserting a new blank column into the sheet. I have line numbers and column headers turned off, and there's nothing in the new column.
Any ideas?
I'm making up some SQL, using QueryTables.add, and returning the results into a cell in the empty column. All of this works fine - the data is being returned correctly.
However, it is also inserting a new blank column into the sheet. I have line numbers and column headers turned off, and there's nothing in the new column.
Any ideas?