fields from Multiple, non-formatted, text files into Access 2002 table
Posted on 2002-05-13
I know i am asking a lot in one question, but i first need to get an idea of the quickest way o get this data into a database, and i only know a little access programing, and even less VB.
To read through multiple files,from single directory. Ther could be up to 1000 files. to search each file for particular data, that is delimeted by specific Html tags
e.g "<title>....</title>". then collect the data from between the delimiters, and place it in fields in the database.
If i can get it to work with one field, as in the above example, ill then move on to further fileds. at this stage, page title, and about 4 other fields are all i need, but that will probably change once i can get data from the pages... he he he!
MY Question: ( finally)
Should this be done in VB, or some form of SQL, or what.
if in VB then how to execute this from Acess, and exactly where to put it on a from.table or macro?
if in SQL then HELP!!!!