Appery.io 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 Appery.io and Click on Databases tab.
ApperyIO4_0.PNG
There are already two databases under my account. Click Create new database.
Create new database window appears. Insert name, herein it is Jan8_2017.
ApperyIO4_1.PNG
Click Create and the database is created as shown. The database is empty and has no collection.
ApperyIO4_2.PNG
Importing a collection: A Collection in Appery.io 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.
ApperyIO4_4.PNG
Click Import.
Data in the FFD.CSV file is now in the appery.io collection in the database Jan8_2017
ApperyIO4_5.PNG
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
ApperyIO4_6.PNG
http://hodentekmsss.blogspot.com/2017/02/importing-csv-text-file-into-ms-
access.html
http://hodentekmsss.blogspot.com/2017/02/importing-text-file-into-ms-access.html
http://hodentekmsss.blogspot.com/2017/01/importing-csv-file-into-sapss-sql.html
http://hodentekmsss.blogspot.com/2016/12/report-based-on-text-file-using-power-bi.html
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 Appery.io and Click on Databases tab.
ApperyIO4_0.PNG
There are already two databases under my account. Click Create new database.
Create new database window appears. Insert name, herein it is Jan8_2017.
ApperyIO4_1.PNG
Click Create and the database is created as shown. The database is empty and has no collection.
ApperyIO4_2.PNG
Importing a collection: A Collection in Appery.io 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.
ApperyIO4_4.PNG
Click Import.
Data in the FFD.CSV file is now in the appery.io collection in the database Jan8_2017
ApperyIO4_5.PNG
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
ApperyIO4_6.PNG
http://hodentekmsss.blogspot.com/2017/02/importing-csv-text-file-into-ms-
access.html
http://hodentekmsss.blogspot.com/2017/02/importing-text-file-into-ms-access.html
http://hodentekmsss.blogspot.com/2017/01/importing-csv-file-into-sapss-sql.html
http://hodentekmsss.blogspot.com/2016/12/report-based-on-text-file-using-power-bi.html
No comments:
Post a Comment