how do i automate text data and input into database?
Hi I am new here..
I have a text file "ap.txt" it contains
88.59.79.8 ** -39 ** 88.59.79.2
88.59.79.8 ** -38 ** 88.59.79.6[attachmentid=703]
88.59.79.8 ** -37 ** 88.59.79.5
I also have a database containing
Microsoft Access Database = database.mdb
table = guards_info
3 columns of Table = ap_id, signal_strength, and mobile_id
Example.
the " ** " ([space]**[space]) are the dividing lines of the data so in all there should be 3 sets of data.
88.59.79.8, -39, and 88.59.79.2 that is suppose to enter into 3 columns "ap_id", "signal_strength", and "mobile_id" respectively into a table known as "guards_info" of a Microsoft Access database known as "database.mdb".
I need a full program that can capture text infomation by the MS DOS command prompt or an auto-refreshing ASP browser program and then input into the Microsoft Access Database automatically without the aid of any physical controls.
The program should try to adapt to changes, based on the text file given ap.txt, when another ap.txt replaces the old ap.txt, there should be a new entry into the database
Example.
ap.txt contains this content..
88.59.79.8 ** -39 ** 88.59.79.2
88.59.79.8 ** -38 ** 88.59.79.6
88.59.79.8 ** -37 ** 88.59.79.5
the "guards_info" should have
---------------------------------------------------------------
| ap_id | signal_strenght | mobile_id |
---------------------------------------------------------------
| 88.59.79.8 | -39 | 88.59.79.2 |
---------------------------------------------------------------
| 88.59.79.8 | -38 | 88.59.79.6 |
---------------------------------------------------------------
| 88.59.79.8 | -37 | 88.59.79.5 |
---------------------------------------------------------------
when I open another text file to write this content..
88.59.79.8 ** -40 ** 88.59.79.7
and save it as ap.txt to replace the old ap.txt, the program should accept the new values and add into another entry in the database.
---------------------------------------------------------------
| ap_id | signal_strenght | mobile_id |
---------------------------------------------------------------
| 88.59.79.8 | -39 | 88.59.79.2 |
---------------------------------------------------------------
| 88.59.79.8 | -38 | 88.59.79.6 |
---------------------------------------------------------------
| 88.59.79.8 | -37 | 88.59.79.5 |
---------------------------------------------------------------
| 88.59.79.8 | -40 | 88.59.79.7 |
---------------------------------------------------------------
I am a total rookie to programming is there anyone willing to lend me this helping hand?? I had attach my "database.mdb" and my "ap.txt" in a "help.zip" folder to this forum, I really will appreciate it if there are any experts who have the codes..
|