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:
[hidden email]
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.htmElecraft web page:
http://www.elecraft.com
Locked
