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!