Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Cmdlet

Get-OfficeAccess

Module PSWriteOffice
Inputs
System.String
Outputs
OfficeIMO.Access.AccessDocument

Reads a native database without running queries, macros, or linked connections.

Syntax

Get-OfficeAccess [-MaxInputBytes <Int64>] [-MaxRows <Int64>] [-Path] <String> [-TableName <String[]>] [<CommonParameters>]
#
Parameter set: All Parameter Sets

Examples

Authored help example

Reads a native database without running queries, macros, or linked connections.

Get-OfficeAccess -Path ./contacts.accdb -TableName Contacts

Parameters

-MaxInputBytes Int64 optional
Maximum source size in bytes.
-MaxRows Int64 optional
Maximum rows traversed by each native reader.
-Path String requiredposition: 0pipeline: True (ByValue, ByPropertyName)aliases: FilePath, FullName, LiteralPath
Literal database filename.
-TableName String[] optional
Optional user-table selection.

Common Parameters

This command supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable.

For more information, see about_CommonParameters.