[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 <scabr...@lifespan.org> > Subject: [sqlite] Ability to convert Access to SQLite > To: sqlite-users@sqlite.or

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

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

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

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread Alan March
09 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 from a wi

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 >

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread scabral
o web browsers ? Can you write in PHP ? > Do you have a web server set up ? > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context:

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

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
kishor >> Nelson Institute, UW-Madison http://www.nelson.wisc.edu >> --- >> Assertions are politics; backing up assertions with evidence is science >> =

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

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

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread scabral
t; === > Sent from Madison, WI, United States > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >

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

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

[sqlite] Ability to convert Access to SQLite

2009-07-22 Thread scabral
to view the data through some sort of front-end (similar to Access form). Thanks scott -- View this message in context: http://www.nabble.com/Ability-to-convert-Access-to-SQLite-tp24609886p24609886.html Sent from the SQLite mailing list archive at Nabble.com