| title | IBCPSession::BCPReadFmt (OLE DB driver) | |
|---|---|---|
| description | The BCPReadFmt method in the OLE DB Driver for SQL Server reads data from a format file that specifies the format of data in the data file. | |
| author | David-Engel | |
| ms.author | davidengel | |
| ms.date | 06/14/2018 | |
| ms.service | sql | |
| ms.subservice | connectivity | |
| ms.topic | reference | |
| ms.custom |
|
|
| helpviewer_keywords |
|
|
| apiname | IBCPSession::BCPReadFmt (OLE DB) | |
| apitype | COM |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics PDW FabricSQLDB]
[!INCLUDEDriver_OLEDB_Download]
Reads format information for each column from the format file.
HRESULT BCPReadFmt(
const wchar_t *pwszFormatFile);
The BCPReadFmt method is used for reading data from a format file that specifies the format of data in the data file. This method is capable of detecting the correct version of the format file. It can automatically detect whether the format file is in xml or old style text format and behaves accordingly. The format file versions supported by the OLE DB Driver for SQL Server BCP are version 6.0 or newer.
After the BCPReadFmt method reads the format values, it makes the appropriate calls to the IBCPSession::BCPColumns and IBCPSession::BCPColFmt methods. There is no need for the user to parse a format file and make these calls.
To save a format file, call the IBCPSession::BCPWriteFmt method. Calls to the BCPReadFmt method can reference saved formats. Alternatively, the bulk-copy utility (bcp) can save user-defined data formats in files that can be referenced by the BCPReadFmt method.
The BCP_OPTION_DELAYREADFMT value of the eOption parameter of IBCPSession::BCPControl modifies the behavior of IBCPSession::BCPReadFmt.
pwszFormatFile[in]
The path and file name of the file containing the format values for the data file.
S_OK
The method succeeded.
E_FAIL
A provider-specific error occurred, for detailed information use the ISQLServerErrorInfo interface.
E_OUTOFMEMORY
Out of memory error.
E_UNEXPECTED
The call to the method was unexpected. For example, the IBCPSession::BCPInit method was not called before calling this method.