Search these areas:
Support Forums
Product Info

DataWeb: What's New
Creating an Application
The DataWeb Designer
Application Management
Data Tables
Data Tables
Data Analysis
-Importing an Access Database
-Importing an Excel Worksheet
-Importing a Text File
-Importing a Web Site
-Importing a Web Archive
Object Model
Full-Text Search
Domain and Email Hosting
HotBlock Modules
Account Management
New Responsive UI Module

DataWeb Help
Support Forums
Script Library
Knowledge Base

Home > Support

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:
  1. From the Start tab in the DataWeb Application Designer, click Import table from an Excel worksheet.
  2. In the Import Excel Data window, paste your Excel data into the text box and click Next.
  3. 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.
  4. When you're done making changes, click Finish at the bottom of the page.
  5. Your new table displays in the Preview tab.
Affiliate | Partner | Terms of Use | Privacy Policy | Contact Us | Pricing | Bring DataWeb In-House    
Email Us