DBFView
help

download

purchase




 


5Star-Shareware - 5 stars


File Mine Rating - 5/5


Tucows Office - 4 cows


Softarea - Useful


SoftList - Good Choice

 

Import XLSX files to DBF base

Import XLSX files to DBF base.

This dialog window imports data from an Excel file. With "Import data into current (opened) database file" option, the DBFView will insert records from xlsx file you selected into current dbf file. In this case the number of fields and field types should be the same as opened dbase file.

If "Import data into another DBF file" is checked, the program will create a new dbf file based on selected Excel xlsx file.

When default locale of your computer is something different from than English, DBFView returns incorrect date value. You are to change your default locale to US to avoid this problem or change the format of date cells to the default type (03/25/2008).



 Convert DBF to Excel 2007



When you export .xlsx files you should take into consideration some limitations:

     1. Rules of the columns names.


- Columns names should be written down one after another (beginning with the cell A1).
- Empty names of the columns are not supported (columns laying to the left are only imported).
- Columns names longer than 8 symbols are truncated up to 8 symbols.


2. Rules of the columns type definition.

The columns type is defined according to the type of the data entered into the second row, i.e. if the integer value is written in the second row that column will be of the integer type.





























 Help Help  Download Download Free Trial  Purchase Buy Now!





How to Open Dbf File   |  Dbf Export to txt/html   |  Convert Dbf to csv   |  Dbf to xls   |  csv dbf Import
Convert DBF to Excel 2007  |  Import xlsx to dbf
Convert xls to dbf   |  Edit Dbf Files   |  Edit Dbf File - Add Records
Edit Dbf Files - Delete Records   |  DBF Reader Recall   |  Dbf Format Pack  |  DBF Files Zap
Dbf Convert Dos/Win   |  Dbfview Columns Dialog   |  Dbf Edit Find Dialog   |  Dbf View Information Dialog
Dbf File Format Preview   |  Dbf Converter Print   |  Dbf File Reader Options Dialog

Copyright (c) 1998 - 2011,    DBFView.com
Home  |  News  |  Help  |  Feedback  |  Contact  |  Download  |  Purchase  |  Screenshot  
All rights reserved.