Vive Corp.
 
 

Documentation

 
Services Products Support Downloads Contact Us About Us Site map

 
 

dataPro

 
 
Prev: Import Text files to the DatabaseNext: dataPro Commands Overview

Import Excel Spreadsheets to the Database

Overview

To import Excel Spreadsheet to the database first select the destination database in the tree view. Then click on the Import Excel File menu item from Tools menu. The Import Excel File dialog box will now appear.

Select Excel file to import by using the Browse button. If the file contains more than one spreadsheet they all will be uploaded to different tables.

If the first row in the Excel file contains field names select "First row is the header" check box. The system will use column names defined in the first row of the spreadsheet when creating the table. Otherwise it will use F1, F2 and so on for column names.

Click the Upload button.

 


Prev: Import Text files to the DatabaseNext: dataPro Commands Overview
 
     

 
Services | Products | Support | Downloads | Contact Us | About Us | Site Map
Copyright 1998-2009 Vive Corp. All rights reserved.