Append output to XLS from MS ACCESS
Currently I have a program that outputs data from a query in different MS Access Databases to an Excel sheet. I use the following code:
Code:
apAccess.DoCmd.OutputTo acOutputQuery, isQuery, "Microsoft Excel 97-2003 (*.xls)"
At present it goes to each db and outputs to it's own excel file, but I want to shorten my work and append the results all in one sheet in one XLS file (and if possible to add a column with an indicator of which db it came from).
Any suggestions?
.
PC - Ubuntu 15.04 64bit Desktop
HP Pav G60-236US 3GB RAM Laptop, Ubuntu 15.04 64bit and Win7 Home
"So Daddy, how come you telling me stealing not right when YOU copying DVDs? How come? How Come?"
RIP Ramesh ...