Good Afternoon Professionals,
I have a notepad text file that needs to be parsed and then various fields to be input into an access table. I've been able to code the steps of gathering the 'Source Code' of the web site in question and saving it in a folder location as a text file. However, I'm having issues, breaking down the various fields within the text file to import into MS Access. A sample text file is attached to this question. The number of lines for each text file will vary. The table that is going to be used to house the input-ed data has not been created yet, so there is creative latitude as I can use a query to "splice" the new data with other database data objects. One last issue is how it is that the "word wrap" feature in notepad can be turned off to assure proper line data placement, if that matters.
Thank you in advance.