Need help convert Txt file to Access!!!!!!!

[linda7255]

Hi There,

I have this text files (URL http://www.orangecountybusiness.org/L.txt ) and wanted to transfer this to my Access database.

Ask you look at that text file, the first work is the legal term than the definition.

Can someone please show me how to transfer this over to Access with one field for the key term and the other fields for definition?

Thanks in advance,
Linda

[moospot]

I would put the file in Excel and parse out the first word (or two words) into a separate column so that the term is in one column and the definition is in another. Then you can save the file as a csv file and import it into Access.

[linda7255]

How do I parse out the first word two words? Do you have instructions on how to do this?

Thanks,
Linda

[moospot]

You would have to use a function to read the first space after the first word. It wont work on two word terms, but you can go back and edit those manually.

Let's assume your target cell is A1

=LEFT(A1, FIND(" ", A1, 1))

This will extract the first word (before the first space) from the text.

=RIGHT(A1, LEN(A1) - FIND(" ", A1, 1))

This will get the rest of the text. Place this in the next cell over. Then you need to copy the two columns you just created, click on Sheet 2 and Click Edit --> Paste Special --> Paste Values. Save the current sheet as a csv file and then you can import it into access.