473,322 Members | 1,403 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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....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
5 1749
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


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
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

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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Vic | last post by:
Dear All, I am getting the following error message : "You cannot assign a value to this object" ("Me.filter =" is highlighted) I have two comboboxes (ByGenes and BySpecies)with lists in them...
5
by: sensible | last post by:
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...
2
by: Marco Ippolito | last post by:
I have an offline DataSet: id (PK, sorted ASC), firstname, enabled 1, Aaron, true 2, Bill, false 3, Charlie, true .... 10001, Mike, false 10002, Nathan, false
2
by: Darren Clark | last post by:
I am currently developing a site that will have a members sectin where data can be posted... Nothing huge there.. My question is, what are some methods that i can use that will stop swear words...
7
by: | last post by:
Hello, Does anyone have an idea on how I can filter the data in the gridview control that was returned by an sql query? I have a gridview that works fine when I populate it with data. Now I...
2
by: engwar1 | last post by:
I'm building a page for a website that will allow for anonymous users to post comments. I want to filter out words deemed offensive or obscene. I know HOW to build this feature but I'm wondering if...
3
by: Charlie Brookhart | last post by:
I have created a program that opens a file and counts words, characters, sentences, etc. I have not used the open file dialog control found in the VB ..NET 2003 toolbox. I instead have used...
0
by: Lyn | last post by:
I have a problem using the form .Filter and .FilterOn properties which causes Access to crash (as detailed in a separate post). The form operates in continuous mode, displaying matching records...
3
by: Zethex | last post by:
Alright I got asked today by a friend this question, which obviously I couldn't help him with. He needs to get rid of words in a string referring to an already given list then needs to map them...
0
by: Eric Wertman | last post by:
You should check out the sets module: http://docs.python.org/lib/module-sets.html
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.