How to export a blank column from an Access db

I am trying to export a .csv file from an Access database using a simple query.
I have the basic mechanism working, but I need to create the .csv files with 2 blank columns.  It is here that I have drawn a blank.
The Access query defines the format of the .csv file, but I can't set up a blank (or dummy) column in the query.

Has anyone any ideas?

Best regards

Richard Tomalin
rltomalinAsked:
Who is Participating?
 
rockiroadsConnect With a Mentor Commented:
If u use query design to create your query, add two new fields like this

BlankCol1: ""
BlankCol2: ""

0
 
rockiroadsCommented:
you can try this in your query

"" as  blankcol1, "" as  blankcol2

in amongst your other fields you have selected
0
 
rltomalinAuthor Commented:
That looks like it.  I knew it would be simple (but so am I sometimes!!)

Best regards
0
 
rockiroadsCommented:
so was it not quite the solution you wanted?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.