Hello,
Does anyone know how to export certain fields from an access table to an excel spreadsheet?
I have a tmp table that I currently transfer into a spreadsheet. The issue is I do not need every field. I only need four of them.
I do not want to create another tmp table with only those four fields for space/complexity purposes.
What I am currently doing is
what I really need is field Column A,B,C,D to transfer to the spreadsheet. Has anyone done anything like this before?
Thanks in advance for your help!
Does anyone know how to export certain fields from an access table to an excel spreadsheet?
I have a tmp table that I currently transfer into a spreadsheet. The issue is I do not need every field. I only need four of them.
I do not want to create another tmp table with only those four fields for space/complexity purposes.
What I am currently doing is
PHP:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "TBL_TMP", "C:\Process_tmp.xls", True
what I really need is field Column A,B,C,D to transfer to the spreadsheet. Has anyone done anything like this before?
Thanks in advance for your help!