Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Cmdlet

Open-OfficeAccess

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

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

Syntax

Open-OfficeAccess
[-MaxInputBytes <Int64>]
[-MaxRows <Int64>]
[-Path] <String>
[-Table <String[]>]
[<CommonParameters>]
#
Parameter set: Path
Open-OfficeAccess
-LiteralPath <String>
[-MaxInputBytes <Int64>]
[-MaxRows <Int64>]
[-Table <String[]>]
[<CommonParameters>]
#
Parameter set: LiteralPath

Examples

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

Open-OfficeAccess -Path ./contacts.accdb -Table 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)sets: Path
Literal database filename.
-Table String[] optional
Optional user-table selection.
-LiteralPath String requiredpipeline: True (ByPropertyName)aliases: FullName, PSPathsets: LiteralPath
Exact input path without wildcard expansion.

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.