By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

Filtering out words?

P: n/a
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....Filtering works on only one column at a time, so I can't
put many columns on one sheet....Any ideas please?
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
se******@screaming.net (sensible) wrote in message news:<90**************************@posting.google. com>...
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....Filtering works on only one column at a time, so I can't
put many columns on one sheet....Any ideas please?


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...
Nov 12 '05 #2

P: n/a


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!
Nov 12 '05 #3

P: n/a
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" <se******@screaming.net> wrote in message
news:40*********************@news.frii.net...


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!

Nov 12 '05 #4

P: n/a

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!
Nov 12 '05 #5

P: n/a
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 <se******@screaming.net> wrote in message news:<40*********************@news.frii.net>...
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!

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.