|
|
 |
You can create a new data table in your web by importing a text file with comma-separated values (.csv) file.
A .csv file contains text data separated by commas, so that a comma indicates where the value of one field ends and the value of the next begins. Individual records are separated by line breaks. Many spreadsheet and database programs support saving files or tables as comma-separated values files.
To create a new data table from a .csv file, click the destination folder for the data table on the Web Directory tab. Click the New button, and under the Import Existing column select Data in a Text File. Enter the path and file name for the text file that you want to import, and indicate whether the first row of the text file contains field names.
When you click the Next button, your text file is uploaded and processed. You're presented with a table showing the first twenty rows of your data. On this page, you can specify a name for your new data table, change field names and data types, and indicate whether a field should be excluded from the new data table. When you're done making changes, click the Finish button at the bottom of the page to create the new table.
When you import a text file, the resulting table's primary key is always created for you on the RowId field, which is an auto-incrementing field of type Integer.
|
