<div>
I've requested that this question be deleted for the following reason:<br />
<br />
sorry
</div>


I've requested that this question be deleted for the following reason:

sorry

<div>
Asker needs to explain what his current status is, and if the expert comment helped.
</div>


Asker needs to explain what his current status is, and if the expert comment helped.

<div>
<div class="content wysiwyg-content">
hi..<br />
how to select only some columns while exporting to csv<br />
<br />
DoCmd.TransferText acExportDelim, , &quot;SELECT [Project Id],[PO NO] &nbsp;FROM [dbo].Tableone]&quot;, strFileName, True, &quot;&quot;<br />
<br />

</div>
</div>


hi..
how to select only some columns while exporting to csv

DoCmd.TransferText acExportDelim, , "SELECT [Project Id],[PO NO]  FROM [dbo].Tableone]", strFileName, True, ""



DoCmd.TransferText select column with alias name

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.