BDE settings have to be created for dbase
See solution details
Create STANDARD database alias in BDEAdmin for DBASE
Make sure excel data convertors are installed.
==============solution details
1. Open BDE Administrator:
START | CONTROL PANEL | BDEADMINISTRATOR
Or search for BDEadmin.exe on local C:\ or Open BDEAdministrator from Windows Explorer, c:\program files\common files\borland shared\bde - double click the BDEAdmin.exe icon (yellow and red).
2. In BDE Administrator:
Click on CONFIGURATION tab (found on the left)
Expand CONFIGURATION
Expand SYSTEM
Click on INIT
3. Within INIT make sure settings are:
AUTO ODBC = FALSE
DATA REPOSITORY =
DEFAULT DRIVER = DBASE (click to change as needed)
LANGDRIVER = 'ascii' ANSI
LOCAL SHARE = TRUE (click to change as needed)
4. After making above changes to INIT,
Right click on white space and choose APPLY
Click YES to save edits.
======================= Part 2
1. In BDE Administrator:
Click on DATABASES tab
Expand DATABASES
Click on STANDARD1 - if it exists
Settings should read:
TYPE = STANDARD
DEFAULT DRIVER = DBASE
ENABLE BCD = FALSE
PATH = T:\DATA\EXPORT
2. If STANDARD1 doesn't exist, right click into white space on the left side panel and choose NEW. A New Database Alias box will appear with STANDARD already showing. Press OK to create, then see settings above and make edits as needed.
Exit BDE window and save all BDE edits.