Need Help In Exporting Access Database Table

[atfaniqbal]

I need a code for only exporting rows from my database table with fieldnames and with specific value in a cell column in to excel sheet with date as filename template....
Please somebody can help

 

[atfaniqbal]

I have a button which does TransferSpreadsheet Cmd but it exports all rows and colums with the fieldnames but i want to export only the rows with cell value of "1" in column E.

Please Help Me Build A Query / Code for this, as i am very newbie in access.
Thanks.

 

[atfaniqbal]

Thanks Bro This Worked...

 

[pr2-eugin]

Thanks Bro This Worked...

Just pointing out.. Pat is a lady.. , you are not the first person to get it wrong.. Although she does not take offense to it..

 

[atfaniqbal]

Need Help In Formatting & Layout For The Exported Query Using The DoCmd.TransferSpreadsheet

 

[MSAccessRookie]

Need Help In Formatting & Layout For The Exported Query Using The DoCmd.TransferSpreadsheet

Simply stated, usng the DoCmd.TransferSpreadsheet method will create a Spreadsheet that resembles the Access Datasheet created when you run the Query. I am not sure what you need to do, but there are other methods available if this is not the Format that you are looking for. More details would be helpful.

-- Rookie