Thursday, February 09, 2017

Importing a CSV file into an Collection supports importing data files in CSV or JSON formats. In this post you will learn the procedure to import a CSV text file.

The file we are going to import is FFD.CSV saved on the files/folders of the local computer which has been imported recently into other data sources such as MS Access 2016 here and here; SAP SQL Anywhere 17; and Power BI. The data file is created by exporting the data from a Query on SQL Server 2012 using the Export/Import Wizard.

Log in to and Click on Databases tab.


There are already two databases under my account. Click Create new database.

Create new database window appears. Insert name, herein it is Jan8_2017.


Click Create and the database is created as shown. The database is empty and has no collection.


Importing a collection: A Collection in is like a table in a relational database.
Now we can either create a collection or import one.

Since we are importing the data we click on the link, import a collection.

The Import data screen is displayed as shown. Provide a name for this collection - SQLServerData. Click on Browse... and locate the file FFD.CSV on your computer.


Click Import.
Data in the FFD.CSV file is now in the collection in the database Jan8_2017


Note that some of the letters in the ProductName came with a ? mark as these are not characters in the English language set.

Here is a sample of the data in the FFD.CSV file


No comments: Protection Status