Is it possible to import data into a subform from a file?

[kknm]

Is it possible to import data into a subform from a excell-file? That is, sequentially read from a given line the entire file specific fields.

[kev1n]

Would the clipboard also be an option to transfer data from excel to the subform (copy & paste) ?

[kknm]

Would the clipboard also be an option to transfer data from excel to the subform (copy & paste) ?

The clipboard does not make sense with a large amount of data. Manual entry will be faster ..
Excell is formed in another firebird database, on another computer in the local network.

[kev1n]

The clipboard does not make sense with a large amount of data. Manual entry will be faster ..

Are you sure? This is how I copy & paste data. In my case, manual data input would take much, much longer:

https://streamable.com/bpqm8k

Excell is formed in another firebird database, on another computer in the local network.

I don't understand this. Are you talking about MS Excel, a spreadsheet?
Where are the files located? How can nuBuilder access them?

[kknm]

I can not open your link. https://streamable.com/bpqm8k
An Excell file is readable from nuBuilder.

[kev1n]

Dude, you need to provide more information.
(See my questions above)

[kev1n]

Do you know where I could upload videos? Because many URLs are blocked in Russia.

[kknm]

Dude, you need to provide more information.
(See my questions above)

The circled in red needs to be imported into the subform, for further editing, there will be additional fields in the line.
Field values ​​begin with '
A file name of type 2020_06_05_D.xls or - 2020_06_05_N.xls
There is a field on the form
Date: 2020-06-05 08:00:00 or 2020-06-05 20:00:00
08:00:00 corresponds to the prefix D in the file name.
20:00:00 corresponds to the prefix N in the file name.

Using the button, you need to open the // vesydyn2 / reports folder and open the file corresponding to the Date field to read.

excell.png

Youtube is available from Russia.
This is a daily operation - there can be from 3 to 20 lines

[kev1n]

copy_paste_excel.gif

[kknm]

As an option, I can try ...
Although this is a lot of operations - find a folder, find a file, open it, select a range, add empty lines to the subform, copy the range, select the field in the first line, paste ...
The added line will also contain fields not from the file.
How to add the required number of lines to a subform?