Blank Field Header

[TallMan]

Hello,

I need to run a query and export it to Excel in a certain format. The format needs to be something like:

Account, blank1, blank2, Client_Name, Address, etc, etc

The problem I am having is getting the blank columns to have blank headers. Is there a work around to get a column to be completely blank?

Thank you,

Tallman

 

[plog]

Just declare a calculated field as blank and give it the name blank:

SELECT Account, "" AS blank1, "" AS blank2, Client_Name, Address
FROM YourTableNameHere;

 

[pbaldy]

My first thought is using spaces for the field names, though I've never tried it.

 

[TallMan]

Hey Plog -

Thanks for the response. I need the whole field to be blank, even the header name. I dont think this is possible as it completely goes against table logic. I may need to find a workaround once the Excel file is created.

 

[pbaldy]

Try

Null As [ ]

 

[TallMan]

Hey Pbaldy,

I am getting the "The expression you entered contains invalid syntax" error. I tried entering it in the design view of the query.

Thank you,

Tallman

 

[pbaldy]

In design view:

[ ]: Null

 

[MSAccessRookie]

Are you using the DoCommand.TransferSpreadsheet Method? I have been told that is all or nothing when it comes to Column Headings.

BobLarson has an approach to Manual transfer of Data that you might be able to use as a start. You can tailor it to yuour needs, but I imagine that if you make a Query that has all of the Required NULL Headers similar (like NULLHEADER1 ... NULLHEADERn), then you could search for the tag NULLHEADER and make those header Cells Null. Give it a try.

http://www.btabdevelopment.com/ts/default.aspx?PageId=48

 

[TallMan]

Thanks for the reply, Gents.

Bob - [ ]: Null did not work either. (In design view)
MXAccessRookie - I will give it a look.

Thanks to both of your for your help.

Tallman