Importing data using VistaDB 2.x OLE DB Provider

VistaDB OLE DB Provider is compatible with any Windows application that supports ADO, such as Crystal Reports, Microsoft Excel and Word.

These screenshots show how to import data into an Excel worksheet.

Select Data | Import External Data | Import Data

Click on the New Source button

Select Other/advanced

Click on VistaDB 2.1 OLE DB Provider

Select the VistaDB .VDB database that you wish to import data from

Select the table database that you wish to import data from

Option 1: OK to import from selected table

Option 2: Edit Query... to edit the SQL statement

At this point, you may continue with importing the data from the table selected above, or you may edit the SQL statement to retrieve data from multiple tables, sort the data etc.

The data will be imported into your Excel worksheet.