[prev in list] [next in list] [prev in thread] [next in thread] 

List:       elecraft
Subject:    [Elecraft] OT: FCC Amateur Radio Database question
From:       "Tom Hall" <tomnyc () mail ! cloud9 ! net>
Date:       2005-01-31 16:43:02
Message-ID: 20050131164302.E3FDBBC45 () english-breakfast ! cloud9 ! net
[Download RAW message or body]

John,

 

I downloaded one of the daily files just to test(it was small).

After un-zipping them:

Rename EN.dat to EN.txt

Make a new empty DB in Access

Go to File/Get External Data/Import

(select "text files")

Load EN.txt

Click the "Delimited" button

Click "Advanced"

Change the Field Delimiter to "|" (shift backslash)

Ok

Finish

Mind you, I just did this out of curiosity. It should be enough to give you
a start.

 

Tom AK2B

 

John wrote

I have downloaded the FCC's Amateur Radio Database.  It came down as 1 ZIP'd


file and expanded into 9 dat files.  I would like to put it on a CD and use 

ACCESS to search it but I need some info about the files and how they are 

structured.  I used FTP and searched around on the FCC's drive but I wasn't 

able to come up with any description of the database.  So I guess I am 

asking if anyone has any info on how the database is laid out, how it is 

delimited, how long the fields are, what info is in each of the files, and 

stuff like that.  Can anyone help?

 

 

-- 

John   K7SVV

_______________________________________________
Elecraft mailing list
Post to: Elecraft@mailman.qth.net
You must be a subscriber to post to the list.
Subscriber Info (Addr. Change, sub, unsub etc.):
 http://mailman.qth.net/mailman/listinfo/elecraft    

Help: http://mailman.qth.net/subscribers.htm
Elecraft web page: http://www.elecraft.com
[prev in list] [next in list] [prev in thread] [next in thread]