Cmdlets for CSV

Build 24.0.9060

IncludeSubdirectories Parameter (Connect-CSV Cmdlet)

Whether to read files from nested folders. In the case of a name collision, table names are prefixed by the underscore-separated folder names.

Syntax

Connect-CSV -IncludeSubdirectories SwitchParameter

Data Type

bool

Default Value

false

Remarks

Whether to read files from nested folders. When accessing local CSV, the cmdlet honors Schema.ini defined in subfolders. Table names are prefixed by each nested folder name separated by underscores only in the case of a table name conflict. For example,

Root\subfolder1\tableARoot\subfolder1\subfolder2\tableA
subfolder1_tableAsubfolder1_subfolder2_tableA

When defining a Schema.ini for local CSV folders, table names do not need to be prefixed in the section names. This allows you to move the folder or use the cmdlet alongside the OLEDB Jet Driver.

Archive files (ZIP, GZ, TAR) are also supported and treated like folders.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060