Filtering out words?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sensible
    #1

    Filtering out words?

    Can I solve this problem using Access? If so, will some give this
    newbie a simple step by step on how to go about it, please....all the
    way from File/New.


    In Excel I am using data/filter/autofilter to filter my long list of
    words, one per row...trouble is in my Excel the columns are only
    60,000 rows deep, and my word list is 1,500,000, This means I have to
    break my list into 26 seperate lists. This makes filtering very
    laborious....Fi ltering works on only one column at a time, so I can't
    put many columns on one sheet....Any ideas please?
    Tags: None
    • Pieter Linden
      #2
      Re: Filtering out words?

      sensible@scream ing.net (sensible) wrote in message news:<90fd0f2b. 0404060940.1155 5aaf@posting.go ogle.com>...[color=blue]
      > Can I solve this problem using Access? If so, will some give this
      > newbie a simple step by step on how to go about it, please....all the
      > way from File/New.
      >
      >
      > In Excel I am using data/filter/autofilter to filter my long list of
      > words, one per row...trouble is in my Excel the columns are only
      > 60,000 rows deep, and my word list is 1,500,000, This means I have to
      > break my list into 26 seperate lists. This makes filtering very
      > laborious....Fi ltering works on only one column at a time, so I can't
      > put many columns on one sheet....Any ideas please?[/color]

      So you're breaking your list up by the first character? (like an
      alphabetized list?) If you wanted, you could import the records into
      Access and then do a filter by form or something like that...

        Comment

        • mike flanagan
          #3
          Re: Filtering out words?



          Pieter, first I need to know how to get my list of 1,500,000 words into
          an Access table....at the moment they are in 30 text files...only then
          can I try to filter them...

          ...the purpose is for a word puzzle I am inventing where one has to find
          words within words, like log is in catalog etc.

          *** Sent via Developersdex http://www.developersdex.com ***
          Don't just participate in USENET...get rewarded for it!

            Comment

            • DC Fan
              #4
              Re: Filtering out words?

              If you know nothing about Access, it may be worse off for you that other
              solutions. However, to answer your question:

              1. File, Get External Data, Import
              2. Set file type to *.xls and browse for your file.
              3. Work with the import wizard to get your data imported.
              4. Do it over and over while you learn about the various issues of importing
              data!
              5. Finally get the data from your first XLS imported.

              6. Try to manipulated data like you did in Excell by cutting and pasting
              columns. Scream when it doesn't work.
              7. Read up on Queries.

              8. Goto step 1 for the new file and try to import the second sheet into the
              existing table you created.
              9. Curse when it doesn't work.
              10. Import the data into a second new table and end up with 8 or 9 different
              tables.
              11. Read up on Apend Queries
              12. FInally get the data into one table.

              Let me know if you need help with your path towards Hell and back out again!
              ;-)

              Steps one through three are actually fairly accurate!

              "mike flanagan" <sensible@screa ming.net> wrote in message
              news:407505ea$0 $199$75868355@n ews.frii.net...[color=blue]
              >
              >
              > Pieter, first I need to know how to get my list of 1,500,000 words into
              > an Access table....at the moment they are in 30 text files...only then
              > can I try to filter them...
              >
              > ..the purpose is for a word puzzle I am inventing where one has to find
              > words within words, like log is in catalog etc.
              >
              > *** Sent via Developersdex http://www.developersdex.com ***
              > Don't just participate in USENET...get rewarded for it![/color]


                Comment

                • mike flanagan
                  #5
                  Re: Filtering out words?


                  Thanks DC Fan......I'll give it a go.


                  *** Sent via Developersdex http://www.developersdex.com ***
                  Don't just participate in USENET...get rewarded for it!

                    Comment

                    • Carlos Nunes-Ueno
                      #6
                      Re: Filtering out words?

                      Look into the Access help files about importing. If your data are
                      delimited in some consistent way, it should be pretty easy to use the
                      import command under the file menu to import the data.

                      mike flanagan <sensible@screa ming.net> wrote in message news:<407505ea$ 0$199$75868355@ news.frii.net>. ..[color=blue]
                      > Pieter, first I need to know how to get my list of 1,500,000 words into
                      > an Access table....at the moment they are in 30 text files...only then
                      > can I try to filter them...
                      >
                      > ..the purpose is for a word puzzle I am inventing where one has to find
                      > words within words, like log is in catalog etc.
                      >
                      > *** Sent via Developersdex http://www.developersdex.com ***
                      > Don't just participate in USENET...get rewarded for it![/color]

                        Comment

                        Previous template Next
                        Working...