Re: How to import a detail file into MS Access

Dale E. Reed Jr. (daler@iea.com)
Mon, 07 Oct 1996 12:18:19 -0700

wwalcher@fullnet.net wrote:
>
> Has anyone come up with a good way to bring the radius detail file into
> Microsoft Access. It would be useful to have a Windows application to do
> lookups on usernames to get a summary of their usage. If you have, would
> you be willing to share the details of how you accomplished this?
>
> The Radius Tacacs software, found at www.hkstar.com/~unet/ has a new
> accounting module that creates a comma-deliminated file of user activity
> that can be easily imported into Access. The new accounting module is
> not part of the current shipping version, but is available from them
> free of charge, and will be part of the new version coming out in a few
> weeks.

det2odbc is a program which takes normal Radius detail files and puts
them into any ODBC database. This program is a part of the RadiusNT
package, and can be found at www.emerald.iea.com. There is a
full example MS Access database in the radnt_33.zip archive you can
use for det2odbc. Generally once you find the power of this, you will
want to run your accounting (you don't have to change your
authentication)
through RadiusNT which can put the information directly into the ODBC
database. This give you the ability to do some real time web displays
to your users also.

-- 
Dale E. Reed Jr.  (daler@iea.com)
_____________________________________________________________________
 Internet Engineering Associates   |  RadiusNT, Emerald, and NT FAQs
  Internet Solutions for Today     |     http://www.iea.com/~daler