Query Wizard - Import from a File

Top  Previous  Next  

 

To Import data from a file, enter the filename you want to use, or select it using the Open File Dialog button.

 

The following file Types are supported.

 

File Types

Descrpition

csv

Comma Delimited

xlsx

Excel Workbook

xls

Excel 97-2003 Workbook

txt

Text

 

clip5861

After selecting the file, click the checkbox if the first row of you file has column headers. Depending on the file type you can then set the Delimiter, use the 'Other' option to set a specific non-standard delimiter.

 

clip5862

 

 

 

Once you have finished making your selections click on the 'Next >' button to go to the Query Wizard - Finished screen.

 

 

 


Copyright © 2003-2017 DataPA Limited, all rights reserved. DataPA OpenAnalytics 6.0