[sqlite] Ability to convert Access to SQLite

2009-07-24 Thread Scott A Tovey
sqlite-users-requ...@sqlite.org wrote: > -- > > Message: 5 > Date: Wed, 22 Jul 2009 09:34:48 -0700 (PDT) > From: scabral > Subject: [sqlite] Ability to convert Access to SQLite > To: sqlite-users@sqlite.org > Message-ID: <24609886.p...@talk

Re: [sqlite] Ability to convert Access to SQLite

2009-07-23 Thread Chris
Since this appears to be a reporting application with multiple readers, why not use an HTML report output and any web browser. Then if you decide to publish the reports on your network, there is little more needed to do so. On Wed, 2009-07-22 at 10:12 -0700, scabral wrote: > Do you know of any thi

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread Rob Sciuk
I believe that one poster (Rich Shepard?) touched upon the MDB-Tools in a response. I concur, if you have the skills to build these tools from source, the rest is easy ... The MDB Tools project hosted on SourceForge has a set of utilities which can enumerate tables, pull data, and schema info

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread Simon Slavin
On 22 Jul 2009, at 6:29pm, scabral wrote: > The OS is Windows XP. I know some VB script, some pearl and i'v > used Visual > VB and C# as well. Post on programming fora about VB (I assume you mean Visual Basic) (whichever version you're using) about accessing SQLite databases. They'll tel

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread Alan March
de 2009 02:30 p.m. > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Ability to convert Access to SQLite > > > The OS is Windows XP. I know some VB script, some pearl and i'v used > Visual > VB and C# as well. > > I was thinking that the script would called

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread Rich Shepard
On Wed, 22 Jul 2009, scabral wrote: > The OS is Windows XP. I know some VB script, some pearl and i'v used Visual > VB and C# as well. > > I was thinking that the script would called from a windows scheduled task > and the script would then import the text file into the table in > SQLite...Sounds

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread scabral
The OS is Windows XP. I know some VB script, some pearl and i'v used Visual VB and C# as well. I was thinking that the script would called from a windows scheduled task and the script would then import the text file into the table in SQLite...Sounds easy, but i'm not sure what's available to cre

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread Simon Slavin
On 22 Jul 2009, at 5:34pm, scabral wrote: > 1. Need to automatically import text file into SQLite database on > local > machine (machine always on). I was thinking of using scheduled task > to run > a script to do this, but not sure if that is possible. What programming languages or script

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread cmartin
On Wed, 22 Jul 2009, scabral wrote: > i am new to SQLite and i currently have an access database that i would like > to convert over to a SQLite database. > > 1. Need to automatically import text file into SQLite database on local > machine (machine always on). I was thinking of using scheduled

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread P Kishor
On Wed, Jul 22, 2009 at 12:12 PM, scabral wrote: > > Do you know of any third party applications that i could use to build the > front end?  This will need to run on local machines, not on servers.  So, > some sort of desktop application i would imagine Applications that build applications? I

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread Rich Shepard
On Wed, 22 Jul 2009, scabral wrote: > Do you know of any third party applications that i could use to build the > front end? This will need to run on local machines, not on servers. So, > some sort of desktop application i would imagine Scott, Each language has its own. However, from yo

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread Nuno Magalhães
> Do you know of any third party applications that i could use to build the > front end?  This will need to run on local machines, not on servers.  So, > some sort of desktop application i would imagine That would be OS-dependent now, wouldn't it? Unless you're going to use Java or PHP or simi

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread scabral
Do you know of any third party applications that i could use to build the front end? This will need to run on local machines, not on servers. So, some sort of desktop application i would imagine thanks Scott P Kishor-3 wrote: > > On Wed, Jul 22, 2009 at 11:34 AM, scabral wrote: >> >> HI,

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread Rich Shepard
On Wed, 22 Jul 2009, P Kishor wrote: > Sure it is possible. You will have to choose your favorite programming > language, write a program to locate and import the local text file, and > set up a scheduler to do so periodically. > Lots of third-party applications. You might end up writing your own

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread P Kishor
On Wed, Jul 22, 2009 at 11:34 AM, scabral wrote: > > HI, > > i am new to SQLite and i currently have an access database that i would like > to convert over to a SQLite database. > > there are a couple of processes that would need to take place in order for > this to work and i'm not sure if SQLite

[sqlite] Ability to convert Access to SQLite

2009-07-22 Thread scabral
HI, i am new to SQLite and i currently have an access database that i would like to convert over to a SQLite database. there are a couple of processes that would need to take place in order for this to work and i'm not sure if SQLite has these capabilities: 1. Need to automatically import text