On Tue, 18 May 2010 17:03:17 +0100, Bart Smissaert
bart.smissa...@gmail.com wrote:
This is a VB6 procedure (in an ActiveX dll) that handles this.
Obviously there are a lot of secondary routines that you don't have,
but I think you will get the general idea of what is going on here.
Thanks a lot
On Mon, 17 May 2010 20:31:07 +0200, Henk Pretorius
preto...@gmail.com wrote:
Try SQLite Manager - a FireFox add on, but can also run stand-alone as
a XUL application.
Thanks, I'll see if it can show data entry forms so non-technies can
handle their database safely.
On Mon, 17 May 2010 22:55:47 -0700, Matt Young
youngsan...@gmail.com wrote:
I have that problem. A solution is an ultra lite SQLite window to
play along side existing spread sheet packages. Then just get read and
write to the spreadsheet happening.
Right. There a millions of users who have
You can run SQL on sheet ranges.
Just need to make sure that the workbook is saved and closed as there is a bug
to do with ADO causing a memory leak.
RBS
On Tue, May 18, 2010 at 11:19 AM, Gilles Ganault gilles.gana...@free.fr wrote:
On Mon, 17 May 2010 22:55:47 -0700, Matt Young
On Tue, 18 May 2010 11:48:06 +0100, Bart Smissaert
bart.smissa...@gmail.com wrote:
You can run SQL on sheet ranges.
Just need to make sure that the workbook is saved and closed as there is a bug
to do with ADO causing a memory leak.
Thanks for the tip. I'll investigate in-place querying in Excel
how to read Excel/OO files and somehow put them into an SQLite database
for better use.
Quite simple that. Basically: range variant array loop through
array and write to SQLite.
Let me know and I will post some example code.
RBS
On Tue, May 18, 2010 at 11:56 AM, Gilles Ganault
On Tue, 18 May 2010 13:18:49 +0100, Bart Smissaert
bart.smissa...@gmail.com wrote:
Quite simple that. Basically: range variant array loop through
array and write to SQLite.
Let me know and I will post some example code.
If you have some basic code to go through Excel or OO sheets to gather
data
This is a VB6 procedure (in an ActiveX dll) that handles this.
Obviously there are a lot of secondary routines that you don't have,
but I think you will
get the general idea of what is going on here.
Public Sub vArray2SQLiteTable(strDB As String, _
vArray As Variant,
Hello
I was wondering: To help people move from Excel to a DB to handle
data, I'd like to show them a really good Windows application that
will enable them to create/read/update/delete records, and should
present users with forms to handle records (not tables, as this is too
abstract for users).
Gilles Ganault gilles.gana...@free.fr schrieb im
Newsbeitrag news:tmr1v5lfsa26lcbooq20sh0q4358jdf...@4ax.com...
I was wondering: To help people move from Excel
to a DB to handle data, I'd like to show them a really
good Windows application that will enable them to
create/read/update/delete
On Mon, 17 May 2010 18:59:36 +0200, Olaf Schmidt
s...@online.de wrote:
I'd say, what you're looking for (in case a softer migration
of Excel-VBA-Devs is planned) is more a library IMO -
and not an Application.
Thanks, I'll check it out. Ideally, I was looking for a tool that
would read data entry
Try SQLite Manager - a FireFox add on, but can also run stand-alone as
a XUL application.
On Mon, May 17, 2010 at 7:55 PM, Gilles Ganault gilles.gana...@free.fr wrote:
On Mon, 17 May 2010 18:59:36 +0200, Olaf Schmidt
s...@online.de wrote:
I'd say, what you're looking for (in case a softer
Gilles Ganault gilles.gana...@free.fr schrieb im
Newsbeitrag news:uk03v5h4ovo8un5hq68ldbotuf1fujr...@4ax.com...
On Mon, 17 May 2010 18:59:36 +0200, Olaf Schmidt
s...@online.de wrote:
I'd say, what you're looking for (in case a softer migration
of Excel-VBA-Devs is planned) is more a library
I have that problem. A solution is an ultra lite SQLite window to
play along side existing spread sheet packages. Then just get read and
write to the spreadsheet happening.
I did that simply with R; I reasoned Windows was smart enough to
handle files, so I just read and write files netween
14 matches
Mail list logo