サポートと今すぐチャット
サポートとのチャット

Toad Data Point 6.4.1 - Release Notes

Create CSV Connections

You can create a connection to a CSV or text file. Once a connection is made to one CSV or text file in a folder, Toad displays all CSV and text files located in the same folder as individual tables in the Object Explorer. In order for all files to display correctly as individual tables, all files must use the same delimiter.

Create a connection to local stored CSV file

  1. Click on the Navigation or Connection Manager toolbar.
  2. Select CSV file from the Group list.
  3. Browse to and select the CSV (or text) file.

  4. Specify the connection properties.

    Delimiter

    Select the type of delimiter used in the CSV (or text) file.

    Custom Delimiter—If delimiter is not a comma or a tab, enter the delimiter used in the CSV (or text) file.

    First row contains column names

    		 Select this option to instruct Toad to read the first row as column names.

    Name

    		 Enter a custom name for the connection

    Category

    		 (Optional) Select an existing category or create a new one to color-code your connection. Set Connection Categories
  5. Click Connect to save the connection and connect immediately. Click Save to save the connection without connecting.
  6. When connected to the CSV or text file, you will notice the following:
    • All CSV and text files within the same folder as the connected file display as tables in the Object Explorer.
    • All files are read according to the delimiter and column header option specified for the connected file.

    • A Schema.ini file is added to the folder. This file sets the delimiter and column header option used to read all the files in the folder. The settings correspond to the last file to which a connection was made.

      For example, if you create a second connection in the same folder, all files are now read according to the delimiter and column header specified for that connection.

  7. In summary:
    • When using this method to display multiple files as separate tables, place all files in one folder and use the same delimiter (and column header format) in each file.
    • When creating an individual connection to each file that uses a different delimiter, place each file in a separate folder.

     

Create a connection to a CSV file stored on SharePoint online

  1. Click on the Navigation or Connection Manager toolbar.
  2. Select CSV file from the Group list.
  3. From the File Source menu select the SharePoint online file.

  4. To successfully connect to your SharePoint account, you need to complete the SharePoint Login information, insert the SharePoint URL, Client ID, Tenant Id, Client Secret.

  5. Browse to and select the CSV file

  6. Specify the connection properties.

    Delimiter

    Select the type of delimiter used in the CSV file.

    Custom Delimiter—If delimiter is not a comma or a tab, enter the delimiter used in the CSV file.

    First row contains column names

    		 Select this option to instruct Toad to read the first row as column names.

    Name

    		 Enter a custom name for the connection

    Category

    		 (Optional) Select an existing category or create a new one to color-code your connection. Set Connection Categories
  7. Click Connect to save the connection and connect immediately. Click Save to save the connection without connecting.

 

Considerations and Limitations

Consideration/Limitation Description

Excel 2016 64-bit or

Office 365 64-bit

To successfully create a connection to a .csv file using Excel 2016 64-bit, the Microsoft Access Database Engine is required and might not have been included in the Excel installation. In addition, the architecture (bitness) of the engine must match the bitness of Toad.

If using 64-bit Toad, the 64-bit version of Microsoft Access Database Engine is required.

If using 32-bit Toad, the 32-bit version of Microsoft Access Database Engine is required.

  1. You can download the 64-bit or 32-bit Microsoft Access Database Engine components at: https://www.microsoft.com/en-us/download/details.aspx?id=54920.
  2. Be sure to select the appropriate version (64-bit or 32-bit) of the AccessDatabaseEngine.exe installer to match the bitness of Toad.

Note: This requirement applies only to connections, not to the Toad functionality of importing/exporting to .csv.

Tip: Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.

  

Related Topics

Connection/Navigation Manager

Understand Toad Connections

Switching Connections in Toad

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択