On 9 Apr 2016, at 6:14am, hfiandor <hfiandor at ceniai.inf.cu> 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.
