If I can get the VB code to read all files in a folder and then print its Filename & Contents to a new file and loop until done, that would be half the work. After I would need from a MySQL writer the code to embed around each section to insert each one as a new record. I will then re-write the VB6.0 code with the MySQL instructions to achieve adding all my text files to a table as described below.
I have a text file on my local computer that i want to add its file name and contents into a new record.
File Name needs to go into Field2 and the actual text needs to go into Field3.
This will require two steps since I cannot read my local files in cpanel from my computer i want to create the required file locally in a text file that i will copy and execute in cpanel.
Using VB 6.0 Create a new text file. ( I have about 200 text files, so it needs to loop).
Read first text file.
Open & write required MySQL syntax to insert record embeding File Name to Field2 and the text contents to field3.
Loop to read all text files.
Print out to new text file. Now open and copy new text file into procedure section to insert new records in cpanel.
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption. Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html). It addresses one of the most common problems that plague beginning PHP develop…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.