Question: i have a powershell script with 2 export-csv to the same file.

But the second export-csv overwrite the previous csv file.

I don't want this.

For the second export-csv, i want write the result to the B column in excel, so i want to export in the same csv file, but to the second column.

The $dataSet.Tables["Query1"] return : 

```
COLUMN1
232

```

The $dataSet.Tables["Query2"] return :

```
COLUMN2
289

```

How to do this?

There is my script : 

```
$mysql = New-Object MySql.Data.MySqlClient.MySqlConnection("server=$serv;port=$port;uid=$user;pwd=$password;database=$db;Pooling=False")
$mysql.Open()

$sqlquery1 = Get-Content "C:\query1.txt"
$sqlquery2 = Get-Content "C:\query2.txt"

$req = New-Object Mysql.Data.MysqlClient.MySqlCommand($sqlquery1,$mysql)
$dataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($req)
$dataSet = New-Object System.Data.DataSet
$dataAdapter.Fill($dataSet, "Query1") | Out-Null
$dataSet.Tables["Query1"] | Export-Csv -path "C:\result.csv" -NoTypeInformation

$req2 = New-Object Mysql.Data.MysqlClient.MySqlCommand($sqlquery2,$mysql)
$dataAdapter2 = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($req2)
$dataSet = New-Object System.Data.DataSet
$dataAdapter2.Fill($dataSet, "Query2")  | Out-Null

$dataSet.Tables["Query2"] | Export-Csv -path "C:\result.csv" -NoTypeInformation

$mysql.Close()

```

Thank you

Answer: 
As @C.B. mentioned, `-Append` doesn't exist in `Export-Csv` before PowerShell 3.0. What you can do in PowerShell 2.0 and earlier is something like this:

```
... | ConvertTo-Csv -NoTypeInformation `
    | select -Skip 1 `
    | Out-File "C:\result.csv" -Append

```
Have a look at the [`Export-CSV` help](http://technet.microsoft.com/library/hh849932.aspx) - the `-Append`switch is what you're after.