six demon bag
Wind, fire, all that kind of thing!
2015-12-30
Save and Restore a DataTable
If you have a DataTable
object in PowerShell and you want to persist that object as a file (and restore it back to a DataTable
object sometime later) the naïve approach would be to export the (tabular) data to a (tabular) CSV:
$dt | Export-Csv -Path 'C:\path\to\table.csv' -NoType
However, the problem with this approach is that you lose the type information for the columns of the datatable (the only type information saved by the Export-Csv
cmdlet is about the type of the objects representing the rows). Also, there's no simple way to restore the CSV back to a datatable.
Posted 17:01 [permalink]