DATABASE FIELD

S

San

Hello

in the following.
"DSN=MS Access Databases; DBQ=C:\\Data\\Sales93.mdb;
FIL=RedISAM" which is used for database merge field.

what does the FIL stand for?

Regards San
 
P

Peter Jamieson

FIL is the file type, e.g. "MS Access", "Excel 3.0", "Excel 4.0", and
various other possibilities.

It may seem strange that a file type can be "Excel 3.0" when the DSN says
"MS Access Databases", but that is because the ODBC driver for Excel/Text
files/some versions of xBASE and one or two other things are all based on
the Access "Jet" provider. In fact they all /are/ the Jet provider.
Internally, the Jet provider uses "IISAMs" (Installable ISAMs) for each type
of file.

As far as I know, "RedISAM" is an old keyword used to indicate aan
Access/Jet .mdb file type. It may still work with modern versions of ODBC
and the Jet provider, but if not, you may need to use "MS Access" instead.
Or you may be able to get away without the entire FIL=RedISAM keyword/value
pair altogether.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top