How to convert .txt file into DB or Excell cell?

[offilaw]

Hi,

To be more eficient in my work y need to scan a formated document for to process by OCR and get de .txt file and then convert to DB or Excel.

Mi idea is that for example the information next to "date1[space]" will be assigned to a cell, all the text between the next keyword.

I'm not a good programmer, so I don't know if that is possible or not. Anyway I will thanks a lot for some orientation.

Greetings.

 

[VBobCat]

Hi,

To be more eficient in my work y need to scan a formated document for to process by OCR and get de .txt file and then convert to DB or Excel.

Mi idea is that for example the information next to "date1[space]" will be assigned to a cell, all the text between the next keyword.

I'm not a good programmer, so I don't know if that is possible or not. Anyway I will thanks a lot for some orientation.

Greetings.

It is possible indeed, in a series of different ways. Which way you should choose depends of what you have and what you are able to do based on your present knowledge.
Most of these ways are below the level of complexity that would suggest writing a .NET application, and that's the reason - I presume - there were no answers so far, because they'd be out of this Forum's target.
But, if I may suggest, Excel itself is able to open .txt files directly. It will assign each line of the text to a row in the worksheet. Then, Excel's "Data" tab has a tool named "Text to Columns", which will allow you to split these lines in many ways.
Try doing this. Furthermore, try record a macro while doing this, and then study the code that is automatically generated. You can reach it by typing Alt+F11. That's not VB.NET, however, but VBA (Visual Basic for Applications - Wikipedia, the free encyclopedia).
These steps are the very way I started programming myself, years ago. It sure demands time and study anyway - there's no other way to perform anything interesting with programmation. But I can say it's worth the effort. Good luck!