DBF reports - Inmport Access

[lalo]

hi all,

we store the report logs in DBF format for easy statistics

1. what exact DBF version is KS-Hostmonitor using ? (access offers DB III, IV and V)
2. i have problems importing into MS ACCESS (version 2000 or 97).

i cannot use excel as we have way to far resultlines.

anyone a hint ?

thanx !
/nik

[lalo]

the problem was, that the filename of the dBase File was too long. the odbc driver can only handle 8.3 filenames. after i renamed the file to maximum 8 characters with 3 characters extension everything worked fine.

[KS-Soft Europe]

the problem was, that the filename of the dBase File was too long. the odbc driver can only handle 8.3 filenames. after i renamed the file to maximum 8 characters with 3 characters extension everything worked fine.

dBase driver came from DOS world so, it could lead to the problems. To avoid such problems I would suggets you to use "Microsoft FoxPro VFP driver" instead of "Microsoft dBase driver"

Regards,
Max