On this site you will find a compressed data file of the Drugs@FDA database. All fields are double-quoted and separated by commas. Each table's primary key, data types, field lengths and nulls appear in the list. While the official online application, Drugs@FDA is updated daily, this data file is updated once per week, on Wednesday. Once you have downloaded the compressed file (drugsatfda.zip), you can unzip the file into 7 text tables. You can then import the tables into a database, spreadsheet or word processing program. Generally a database program is the best program to use for these types of files. They offer little guidance on how to construct your database design, as each user has different requirements or uses. This has been added to Healthcare Resources Subject Tracer™ Information Blog. This will be added to Healthcare Resources 2005 Internet MiniGuide.
posted by Marcus Zillman |
8:14 AM
