bcpRead: Bcp read

In bowerth/stan: Structural Analysis

Description

Use bcp to read from SQL

Usage

bcpRead(table = NULL, server = NULL, bcpOUT = "-w -T", file.data = NULL)

Arguments

table	a character string specifying the SQL table in the form [DBname].dbo.[TableName].
server	a character string specifying the SQL server containing the database specified with ‘table’.
bcpOUT	a character string passing additional argumens to the bcp utility for writing data from Microsoft SQL Server.

Details

Use the bcp utility to read data from a table on Microsoft SQL Server

Author(s)

OECD STAN

See Also

bcpWrite

Examples

data <- bcpRead(table="STAN.dbo.STANPUB", server="VS-GEN-SQL-3")
head(data)

bowerth/stan documentation built on May 13, 2019, 12:38 a.m.