I am looking for a tool to be made to convert some data I have in a .txt (flat file ms-dos text file) to an Access 2000 database.
I have many of these files in 1 directory.
I need the first 7 lines of every file to be inserted into a table, called Materials with each line placed in a different field with the field names: (ex: Line1, Line2, and so on).
Lines 8 through the end of the file need to be inserted into a different table called Chemicals. In this table it will need to contain 2 fields, the first Line of the file and the Line being inserted from Line 8 to the end of the file.
And also from Lines 8 to the end of the file, before the line is inserted, I would like a SELECT query made from the same data about to be inserted ran to check for duplicates in the Chemicals table because some data in each file will be duplicated.
I want a program created where I can see a form with a file dialog on it. I can then Select the directory I would like to insert the files from into the database.
I want an Access 2000 database created and named DB.mdb.
The field sizes I need are all 100 character length text fields with the exception of Line 1 of every file which is a long Integer field.
I am looking for a **quick turn around time**. I will reward the coder if they can come through on a fast correctly working application. I am also ready to accept if someone can finish the project in a few hours time.
I would prefer Visual Basic 6, or second would be VB.NET
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Visual Basic 6
Visual [login to view URL]
Microsoft Access 2000