Background Image

DOCUMENTATION

?

Shortcut

PrevPrev Article

NextNext Article

Larger Font Smaller Font Up Down Go comment Print Attachment

 

Author: Juwon Kang

 

I am sure that many of you write a lot of data into Excel. CUBRID Manager provides simple and easy data entry into the UI. And the function is called import.

 

Import is a function to import schema and data from a file to the database server. (Schema only supports SQL files, and data supports SQL, CSV, XLS, and TXT.)

 

The Import Wizard consists of three steps below:

Step 1: Select import type

Step 2: Select data sources and options to import

Step 3: Check import options

import.png

improt_data1.PNG

 

improt_data2.PNG

Here's a tip!

 

XLSX file is a file format added since Excel 2007, and CUBRID Manager does not support XLSX file, so data import operation using XLSX file as a source cannot be guaranteed. Therefore, XLSX files must be converted to XLS files through the "Save As" menu before use.

 

And when saving as an XLS file, pay attention to the file character set! For example, in the Korean version of Excel, if the character set is not set separately, the default encoding is EUC-KR, so if data is imported that does not match the character set option of the file, character corruption occurs. In this case, set the file character set to EUC-KR in the import option to solve the problem.

improt_data3.PNG

 

 


  1. eXERD Which Deals with Logical/Physical Models, Supports CUBRID

  2. Let’s Take a Look at SQLGate for CUBRID!

  3. Utilizing the CUBRID Migration Tool (CMT)

  4. 23Jul
    by charischau
    2020/07/23 in Tools

    CUBRID Manager Import Wizard Useful Tips!

  5. Running CUBRID Container Services in Docker, Kubernetes Environment

  6. No Image 17Jul
    by
    2020/07/17 in Server

    How to Start CUBRID Automatically upon LINUX Boot

  7. What's New in CUBRID 10: 'String Compression'

  8. No Image 17Jul
    by
    2020/07/17 in Server

    CUBRID GRANT ALL TABLES

  9. No Image 17Jul
    by
    2020/07/17 in Server

    Using Two-way Encryption Functions with Java SP in CUBRID

  10. No Image 17Jul
    by
    2020/07/17 in Server

    Changing the LOB Data Path

Board Pagination Prev 1 2 3 4 Next
/ 4

Join the CUBRID Project on