[ Home ] [ Features ] [ Products ] [ FAQ's ] [ Screens ] [ Support ] [ Downloads ] [ About ] [ Discussion ]


the software that grows with you

 

V32Db2Excel()

Opens a .DBF file as an Excel Sheet.

Syntax

V32Db2Excel( <cFileDbf> )

Arguments

cFileDbf Character string to represent database file ( .Dbf ) with full drive and path attributes.

Returns

NIL

Description

This function belongs to the family of Excel functions, such as, V32Brw2Excel(), V32Excel() and V32ExcelScript(). It opens a database file as an Excel sheet through Excel active-x component. 

Note that this function  does not delete the file submitted to Excel neither its format is changed, so can be freely used to view contents of a database as an Excel sheet.  

It is extremely fast.

Usage

V32Db2Excel( CurDir()+'\vouch32.dbf' )

Tips

As there was an error in V32Excel() function when data of type 'Date' is furnished in array submitted to Excel, this function allows you to create a temporary database from the array and then submit that database with V32Db2Excel().

 

[ Home ][ Features ] [ Products ][ About Us ][ FAQ's ][ Screen Shots ][ Downloads ][ Support ][ Discussion ]
.

Vouch is a Trademark of Pritpal Bedi
All other Trade Marks are the property of their respective owners.
Copyright 1993-2011 Pritpal Bedi. All rights reserved.
Hit Counter  
You are Visitor # since 14 May 2002