Search these areas:
Help
Support Forums
Product Info



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





DataWeb Help
Support Forums
Tutorial
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    
DataWeb, 720 North 10th Street, A #145, Renton, Washington 98057 *425-583-5970* Fax 484-770-4706* Email Us