Access help needed

[Megadeth]

I have a text file that looks like the following:

Adrian Public Library/city
143 East Maumee Street
Adrian, MI 49221-2703
Jule J. Fosbender, Director
Email: jfosbend@monroe.lib.mi.us
URL: http://adrian.lib.mi.us
517-265-2265
Fax: 517-265-8847
M,Tu,Th 10-9; W,F 10-5:30; Sa 9:30-5
County: Lenawee
Coop: Woodlands
Lenawee County Library/co/Michicard
4459 West U.S. 223
Adrian, MI 49221-9461
Karen E. Lindquist, Director
Email: klindqui@monroe.lib.mi.us
URL: http://www.lenawee.lib.mi.us
517-263-1011
Fax: 517-263-7109
M 10-9; Tu-Sa 10-6
County: Lenawee
Coop: Woodlands

This continues for over 100 pages.... It is a list of libraries in Michigan. I need to take this text file and put it into eitehr Excel or Access for easier record finding and cheanging.

I don't know from this example if you can see it but there are some Libraries that have more "fields" than others....

The only common thing I think is that at tthe begining of every new Library it has the word Library.... I have not gone throught the entier text file to verify this, but I do know that there are a couple other places in the text file where the word Library shows up.....
Examples:
Librarian@tlnLibrary.com
105 Library Lane

This seems like a tough project.. especially only on 3 hours of sleep. Can anyone figure out a way to seperate these Libraries?

 

[Modeps]

It would have been easy if the file was in a tab-delimited format, but it's line-break delimited, which is stupid and no one does if it's a data file... so well, search and repace, changing all line breaks to tabs, then add the line breaks by hand afterwards.

 

[b4u]

The way I see it, and specially without fields limit, I would say you can do it only with some programming work. No easy import feature that breaks the data to the format you want it ... it's even a bit harder to look it yourself as it is ...

 

[KLin]

would it be safe to say that there are always 11 lines of information for each library, with each library having the information in the same order?

 

[Megadeth]

Some libraries have more lines of information than others. Another problem is that the information is not all in the same order.... I was trying to think of a way to use a macro for this...

It looks like I will have to be doing part of this manually....

 

[EagleKeeper]

You will have to read each line and analyze it.

Knowing the start of a master record (Library) will help.
After that you will have to look for key words to dtermine which field the file line belongs to.
For lines that can not be parsed out, store them in a generic field.

Then you will have to manually go into the DB and look at the fields that are generic and move them around by hand.