I want a script that can import data from a text file, and append them to a table, based on teh column names
the tricky part is the column names are in the row in the text file:
issue number: 123456
Company ID: we24
Store ID: s09
issued By: Julie
compliant ID: abc231
Subject: login failure
Description: related to the login to the system, cant get access and forgot password link is not activated.
responseby: 24 hours
ticket number: 12234
each word before : is the field name, and the data after the : is the field data.
There are many text tiles like this, so i want the procedure to upload the data from the text file to a table just through one click of a button, so that the records are appended and I can later user the records for other purposes.
* * *This broadcast message was sent to all bidders on Wednesday Dec 15, 2010 10:14:50 AM:
Hello, Thank you very much for bidding on this project. I have received so many responses for this project that I have not had any time to go through all of them! I do a lot of customs MS Access Application or web application for various clients, would like to definitely contact you for future projects. At the moment I am also looking for some experienced MS Access programmers for some small to mid-sized MS Application projects. If you would like to know more about some of the upcoming projects, and If you would like to keep in touch with me for future projects, please add me on your skype. My id is "Marinah51" so I have your contact details to contact you instantly and also easy to keep in touch for future projects as well. I also put all my projects on RAC, hence you will hear bout it on RAC too but if I have you on Skype then it gets easier for me to communicate also. Thanks and look forward to hearing from you.