Exporting excel file from Access, how to add additional columns?

[ncsthbell]

I am using a query to select my columns from a table and then I am using the export function to export the results to an excel spreadsheet. I need to add to blank columns to the end, "Verified Year" and "Verified By". These columns are not on the table. I know I can manually add them to the excel spreadsheet but I am creating an automated process using vba code to create & export this so there will not be any manual intervention. Therefore, when the query is executed (select colA, colB, colC from table), I need to have this select statement somehow create these 2 additional columns.
Any suggestions?

Thanks!

[NeoPa]

I would have thought creating empty columns in your query with the names to match the columns you want should work fine for you.

[ncsthbell]

I have tried "select mytable.colA, mytable.colB, mytable.colC, "add_column1"
from mytable;

This give me the header 'Expr1007' and populates each row with the data value "add_column1". What I need is the column header to be "add_column1" and the data rows should be empty.

I have tried several different ways to do this and have not been succesful.

Thanks

[NeoPa]

Try using :

SELECT mytable.colA
     , mytable.colB
     , mytable.colC
     , Null AS Add_Column1

[ncsthbell]

That worked! Thanks. Some times I tend to over think the simple things! Thanks for your quick response!

[NeoPa]

No worries. These things are always so much easier when you've done them before many times.