S SirPoonga Feb 23, 2005 #1 Output query to excel via code? Would this be a job for TransferSpreadsheet or OutputTo? And how would I do it?
Output query to excel via code? Would this be a job for TransferSpreadsheet or OutputTo? And how would I do it?
M [MVP] S.Clark Feb 23, 2005 #2 TransferSpreadsheet is fine. Create a new macro, add the action, enter the parameters, then run the Macro.
TransferSpreadsheet is fine. Create a new macro, add the action, enter the parameters, then run the Macro.
S SirPoonga Feb 23, 2005 #3 I decided to use Output To because I output a query and a table to excel withing two lines of code. Looks nicer in code Now, how do I export the code so the first row isn't highlightes in gray?
I decided to use Output To because I output a query and a table to excel withing two lines of code. Looks nicer in code Now, how do I export the code so the first row isn't highlightes in gray?
K Ken Snell [MVP] Feb 24, 2005 #4 Use TransferSpreadsheet. It doesn't export as a formatted output, which is what OutputTo is doing. Also, OutputTo will truncate the export at 16,384 records, and will truncate all text strings longer than 255 characters.
Use TransferSpreadsheet. It doesn't export as a formatted output, which is what OutputTo is doing. Also, OutputTo will truncate the export at 16,384 records, and will truncate all text strings longer than 255 characters.