DataWeb User's Guide

Importing an Excel Worksheet You can create a new data table in your Web by copying a block of data from an Excel spreadsheet to the clipboard and pasting it into your DataWeb Web. When you import an Excel spreadsheet, the primary key in the resulting table is always created for you on the RowId field, which is an auto-incrementing field of type Integer. Note that you can use this method to paste any tab-delimited data to create a new table. To import a table from an Excel worksheet: From the Start tab in the DataWeb Application Designer, click Import table from an Excel worksheet. In the Import Excel Data window, paste your Excel data into the text box and click Next. The Set Table Properties window displays the first 20 rows of your data. 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 Finish at the bottom of the page. Your new table displays in the Preview tab.