[sqlite] application for initial charge

[Jean-Christophe Deschamps]

At 07:14 09/04/2016, you wrote:
>I have implemented an application with Lazarus+FPCompiler, using SQLite
>tables, and the information was obtained from Excel tables previously 
>done.
>
>I hope it would be very simple to prepare in the former Excel tables a 
>sheet
>with the information required by my application and "charge it" instead of
>the manual introduction as now.
>
>Please, if somebody knows something about this aspect, I will appreciate
>very much any information.

I would use a powerful scripting language for that, AutoIt, which makes 
it very easy to interface SQLite and automate Excel as well.
See https://www.autoitscript.com/site/autoit/

--
jcd 

[sqlite] application for initial charge

[hfiandor]

Thanks very much to Jean-Christophe Deschamps

Regards
Ing. H?ctor F. Fiandor Rosario

[sqlite] application for initial charge

[Simon Slavin]

On 9 Apr 2016, at 6:14am, hfiandor  wrote:

> I hope it would be very simple to prepare in the former Excel tables a sheet
> with the information required by my application and ?charge it? instead of
> the manual introduction as now.

Take a copy of your Excel spreadsheet.
Add a new column something like

=CONCATENATE("INSERT INTO myTable VALUES (",a1,",",a2,")")

So that it constructs the INSERT commands itself.  When you have all the 
commands you need copy and paste them into a text file.

Then use your own programming or the SQLite shell tool to execute those 
commands.

Simon.

[sqlite] application for initial charge

[hfiandor]

Dear list members:



Recently I have worked with an application for initial charge of an
Accounting System. It was very simple and I suspect that was implemented
with EXCEL and the Accounting System BD motor is not an SQLite (maybe
FoxPro).



The main idea is to prepare an accounting entry (I don?t know how to name it
in english but in spanish it is known as ?comprobante?) in Excel, in a
special layout, press a button, and generate the entry in a way that the
Accounting System can ?read? when it was ?imported?.



I have implemented an application with Lazarus+FPCompiler, using SQLite
tables, and the information was obtained from Excel tables previously done.



I hope it would be very simple to prepare in the former Excel tables a sheet
with the information required by my application and ?charge it? instead of
the manual introduction as now.



Please, if somebody knows something about this aspect, I will appreciate
very much any information.



Thanks

Ing. H?ctor F. Fiandor Rosario