Power BI Connector for Sage Business Cloud Accounting

Build 22.0.8342

COPY Bulk Data Transfer

copybulkdatatransfer コマンドは、ファイルから大量のデータをロードしてテーブルに入力します。

COPY Bulk Data Transfer 構文

    sql format: 
    COPY _table[(_column1, _column2 ...)] from '_path' [WITH] _options;

    JDBC case:
    statement.execute("COPY public.t_copy2 from 'D:\\DB\\CSV\\t_copy2.csv' WITH DELIMITER ',' CSV HEADER");

    .NET case:
    DbCommand dbCommand = conn.CreateCommand();
    dbCommand.CommandText = "COPY public.t_copy2 from 'D:\\DB\\CSV\\t_copy2.csv' WITH DELIMITER ',' CSV HEADER";
    int count = dbCommand.ExecuteNonQuery();

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8342