Re: [sqlite] reading MS Access 97 files

2008-04-11 Thread John Grant 
Many thanks, Fred.
-John


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Fred J. Stephens
Sent: Thursday, April 10, 2008 7:36 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] reading MS Access 97 files

Rich Shepard wrote:
> On Thu, 10 Apr 2008, Fred J. Stephens wrote:
> 
>> But to us former Access users, "database" is quick shorthand.
> 
> Fred,
> 
>Access is a joke. At least, that's what my colleagues who must work
in the
> Microsoft world tell me.
I agree. Thats why I said "former" user. Anyway, I am rusty in Access, 
haven't used
it since switching to Linux 4-5 years ago. I had forgotten all about the

DAO, ADO stuff
that Michael mentioned.

>> And I did say later in the post that sqlite is a database engine.
> 
>That's ambiguous.
If it's good enough for DRH to refer to it thus on his website, it's 
good enough for me! :-)
I understand the distinction, but I was just trying to help John get a 
quick overview of the situation until more knowledgeable users chimed
in.
Now they have, so I will bow out.
Fred Stephens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-11 Thread Michael Ruck 
Even though I haven't done anything with this stuff for almost 6 years, I
haven't forgotten this stuff. But I intentionally left out a couple of short
lived technologies... :(

Mike 

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von Fred J. Stephens
Gesendet: Freitag, 11. April 2008 04:36
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] reading MS Access 97 files

Rich Shepard wrote:
> On Thu, 10 Apr 2008, Fred J. Stephens wrote:
> 
>> But to us former Access users, "database" is quick shorthand.
> 
> Fred,
> 
>Access is a joke. At least, that's what my colleagues who must work 
> in the Microsoft world tell me.
I agree. Thats why I said "former" user. Anyway, I am rusty in Access,
haven't used it since switching to Linux 4-5 years ago. I had forgotten all
about the DAO, ADO stuff that Michael mentioned.

>> And I did say later in the post that sqlite is a database engine.
> 
>That's ambiguous.
If it's good enough for DRH to refer to it thus on his website, it's good
enough for me! :-) I understand the distinction, but I was just trying to
help John get a quick overview of the situation until more knowledgeable
users chimed in.
Now they have, so I will bow out.
Fred Stephens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-11 Thread ajm 
Perhaps this URL can help you

http://www.allbusiness.com/technology/software-services-applications-programming/5893603-1.html

Good luck, and greetings

Adolfo.

-Original Message-
From: John Grant [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 10, 2008 05:59 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] reading MS Access 97 files

I need a library that can help me load that same data into myapplication. It 
does not help me to view the data in MS Access or otherapplications.


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-10 Thread Fred J. Stephens 
Rich Shepard wrote:
> On Thu, 10 Apr 2008, Fred J. Stephens wrote:
> 
>> But to us former Access users, "database" is quick shorthand.
> 
> Fred,
> 
>Access is a joke. At least, that's what my colleagues who must work in the
> Microsoft world tell me.
I agree. Thats why I said "former" user. Anyway, I am rusty in Access, 
haven't used
it since switching to Linux 4-5 years ago. I had forgotten all about the 
DAO, ADO stuff
that Michael mentioned.

>> And I did say later in the post that sqlite is a database engine.
> 
>That's ambiguous.
If it's good enough for DRH to refer to it thus on his website, it's 
good enough for me! :-)
I understand the distinction, but I was just trying to help John get a 
quick overview of the situation until more knowledgeable users chimed in.
Now they have, so I will bow out.
Fred Stephens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-10 Thread Michael Ruck 
John,

If you want to go the ODBC route, then that's the way to go. The Access ODBC
Driver docs can be found at
http://msdn2.microsoft.com/en-us/library/ms710302(VS.85).aspx

Mike

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von John Grant
Gesendet: Freitag, 11. April 2008 03:19
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] reading MS Access 97 files

Mike,
Thanks for the advice - that's the info I've been trying to find.

When you say 'ODBC API'- is this what you are thinking?
http://msdn2.microsoft.com/en-us/library/ms714562(VS.85).aspx

Thanks,
-John


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Ruck
Sent: Thursday, April 10, 2008 5:58 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] reading MS Access 97 files

John,

Access comes with an ODBC driver itself. An alternative would be to access
the MS-Jet-Engine directly. (Jet is the database engine used by Microsoft
Access.)

IMHO you have three/four data access APIs possibilities:

- ODBC
- Jet Engine
- DAO
- ADO (not ADO.NET)

Choose one depending on your circumstances. All of these APIs can natively
access Access databases on Windows if the Microsoft Data Access Components
are installed (those include the Jet-Engine driver.)

Mike

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von John Grant
Gesendet: Freitag, 11. April 2008 02:54
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] reading MS Access 97 files

@Fred,
Thanks for the overview!

I'll start looking for an ODBC driver that I can use from C++ (not Managed
C++).  I guess I need a driver that works with Access 97 files.
The code I am porting to C++ makes a "connection" with this string:
Provider=Microsoft.JET.OLEDB.4.0

I hope to find a class library for C++ (so far I've only seen MC++
classes) that allows me to use an interface which is not directly tied to
the driver DLL.  If multiple drivers will do the job, I want my code to be
able to use the "best/default".

-John



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Fred J. Stephens
Sent: Thursday, April 10, 2008 4:13 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] reading MS Access 97 files

John Grant wrote:
> @All,
> 
> Thanks for the replies.  I would like to say that I am new to this,
and
> I've spent many hours trying to find documentation so that I don't
look
> like an idiot on any forums.  :)  With that said, I'm very confused.
No problem, I am probably going to make one out of myself, but I will try to
help until more competent advice comes along.

> I guess I was under the impression that SQLite was a library for
reading
> databases of various formats. 
No, SQLite IS a database. It can be used to replace others like Access,
MySQL etc. However, (and I went through this confusion when moving to Linux
and away from Access) Access is more than a database engine, it also a
report generator, query creator, form designer, etc.
SQLite is just the database engine (or library or command line tool).
You provide your own code to create the tables, insert data, and work with
it.

  I have a file that can be viewed with MS
> Access.  I have tested this myself.  Open Office immediately closed 
> (probably crashed) when I tried to open the file with its 'Base'
> program.  I need a library that can help me load that same data into
my
> application.  It does not help me to view the data in MS Access or
other
> applications.
What language is your application written in? You may be able to use the
ODBC driver from within that language.

> What do you mean when you say I need a driver?  Are you telling me
that
> SQLite can read the file or not?  If not, do you know of a library
that
> will help me with my task?
An ODBC (Open Database Connectivity) driver lets you read data out of a
database, without having it's native application. I think that is roughly
correct. So, no, SQLite won't open the file and won't help you until you get
the data out of Access format. The only way I know offhand

to do that without exporting it in csv (comma separated values) or
something, is an ODBC driver.
Hope this helps.
Fred Stephens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-10 Thread John Grant 
Mike,
Thanks for the advice - that's the info I've been trying to find.

When you say 'ODBC API'- is this what you are thinking?
http://msdn2.microsoft.com/en-us/library/ms714562(VS.85).aspx

Thanks,
-John


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Ruck
Sent: Thursday, April 10, 2008 5:58 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] reading MS Access 97 files

John,

Access comes with an ODBC driver itself. An alternative would be to access
the MS-Jet-Engine directly. (Jet is the database engine used by Microsoft
Access.)

IMHO you have three/four data access APIs possibilities:

- ODBC
- Jet Engine
- DAO
- ADO (not ADO.NET)

Choose one depending on your circumstances. All of these APIs can natively
access Access databases on Windows if the Microsoft Data Access Components
are
installed (those include the Jet-Engine driver.)

Mike

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von John Grant
Gesendet: Freitag, 11. April 2008 02:54
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] reading MS Access 97 files

@Fred,
Thanks for the overview!

I'll start looking for an ODBC driver that I can use from C++ (not Managed
C++).  I guess I need a driver that works with Access 97 files.
The code I am porting to C++ makes a "connection" with this string:
Provider=Microsoft.JET.OLEDB.4.0

I hope to find a class library for C++ (so far I've only seen MC++
classes) that allows me to use an interface which is not directly tied to
the driver DLL.  If multiple drivers will do the job, I want my code to be
able to use the "best/default".

-John



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Fred J. Stephens
Sent: Thursday, April 10, 2008 4:13 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] reading MS Access 97 files

John Grant wrote:
> @All,
> 
> Thanks for the replies.  I would like to say that I am new to this,
and
> I've spent many hours trying to find documentation so that I don't
look
> like an idiot on any forums.  :)  With that said, I'm very confused.
No problem, I am probably going to make one out of myself, but I will try to
help until more competent advice comes along.

> I guess I was under the impression that SQLite was a library for
reading
> databases of various formats. 
No, SQLite IS a database. It can be used to replace others like Access,
MySQL etc. However, (and I went through this confusion when moving to Linux
and away from Access) Access is more than a database engine, it also a
report generator, query creator, form designer, etc.
SQLite is just the database engine (or library or command line tool).
You provide your own code to create the tables, insert data, and work with
it.

  I have a file that can be viewed with MS
> Access.  I have tested this myself.  Open Office immediately closed 
> (probably crashed) when I tried to open the file with its 'Base'
> program.  I need a library that can help me load that same data into
my
> application.  It does not help me to view the data in MS Access or
other
> applications.
What language is your application written in? You may be able to use the
ODBC driver from within that language.

> What do you mean when you say I need a driver?  Are you telling me
that
> SQLite can read the file or not?  If not, do you know of a library
that
> will help me with my task?
An ODBC (Open Database Connectivity) driver lets you read data out of a
database, without having it's native application. I think that is roughly
correct. So, no, SQLite won't open the file and won't help you until you get
the data out of Access format. The only way I know offhand

to do that without exporting it in csv (comma separated values) or
something, is an ODBC driver.
Hope this helps.
Fred Stephens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-10 Thread Michael Ruck 
John,

Access comes with an ODBC driver itself. An alternative would be to access
the MS-Jet-Engine directly. (Jet is the database engine used by Microsoft
Access.)

IMHO you have three/four data access APIs possibilities:

- ODBC
- Jet Engine
- DAO
- ADO (not ADO.NET)

Choose one depending on your circumstances. All of these APIs can natively
access Access databases on Windows if the Microsoft Data Access Components
are
installed (those include the Jet-Engine driver.)

Mike

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von John Grant
Gesendet: Freitag, 11. April 2008 02:54
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] reading MS Access 97 files

@Fred,
Thanks for the overview!

I'll start looking for an ODBC driver that I can use from C++ (not Managed
C++).  I guess I need a driver that works with Access 97 files.
The code I am porting to C++ makes a "connection" with this string:
Provider=Microsoft.JET.OLEDB.4.0

I hope to find a class library for C++ (so far I've only seen MC++
classes) that allows me to use an interface which is not directly tied to
the driver DLL.  If multiple drivers will do the job, I want my code to be
able to use the "best/default".

-John



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Fred J. Stephens
Sent: Thursday, April 10, 2008 4:13 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] reading MS Access 97 files

John Grant wrote:
> @All,
> 
> Thanks for the replies.  I would like to say that I am new to this,
and
> I've spent many hours trying to find documentation so that I don't
look
> like an idiot on any forums.  :)  With that said, I'm very confused.
No problem, I am probably going to make one out of myself, but I will try to
help until more competent advice comes along.

> I guess I was under the impression that SQLite was a library for
reading
> databases of various formats. 
No, SQLite IS a database. It can be used to replace others like Access,
MySQL etc. However, (and I went through this confusion when moving to Linux
and away from Access) Access is more than a database engine, it also a
report generator, query creator, form designer, etc.
SQLite is just the database engine (or library or command line tool).
You provide your own code to create the tables, insert data, and work with
it.

  I have a file that can be viewed with MS
> Access.  I have tested this myself.  Open Office immediately closed 
> (probably crashed) when I tried to open the file with its 'Base'
> program.  I need a library that can help me load that same data into
my
> application.  It does not help me to view the data in MS Access or
other
> applications.
What language is your application written in? You may be able to use the
ODBC driver from within that language.

> What do you mean when you say I need a driver?  Are you telling me
that
> SQLite can read the file or not?  If not, do you know of a library
that
> will help me with my task?
An ODBC (Open Database Connectivity) driver lets you read data out of a
database, without having it's native application. I think that is roughly
correct. So, no, SQLite won't open the file and won't help you until you get
the data out of Access format. The only way I know offhand

to do that without exporting it in csv (comma separated values) or
something, is an ODBC driver.
Hope this helps.
Fred Stephens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-10 Thread John Grant 
@Fred,
Thanks for the overview!

I'll start looking for an ODBC driver that I can use from C++ (not
Managed C++).  I guess I need a driver that works with Access 97 files.
The code I am porting to C++ makes a "connection" with this string:
Provider=Microsoft.JET.OLEDB.4.0

I hope to find a class library for C++ (so far I've only seen MC++
classes) that allows me to use an interface which is not directly tied
to the driver DLL.  If multiple drivers will do the job, I want my code
to be able to use the "best/default".

-John



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Fred J. Stephens
Sent: Thursday, April 10, 2008 4:13 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] reading MS Access 97 files

John Grant wrote:
> @All,
> 
> Thanks for the replies.  I would like to say that I am new to this,
and
> I've spent many hours trying to find documentation so that I don't
look
> like an idiot on any forums.  :)  With that said, I'm very confused.
No problem, I am probably going to make one out of myself, but I will 
try to help
until more competent advice comes along.

> I guess I was under the impression that SQLite was a library for
reading
> databases of various formats. 
No, SQLite IS a database. It can be used to replace others like Access, 
MySQL etc. However, (and I went through this confusion when moving to 
Linux and away from Access) Access is more than a database engine, it 
also a report generator, query creator, form designer, etc.
SQLite is just the database engine (or library or command line tool).
You provide your own code to create the tables, insert data, and work 
with it.

  I have a file that can be viewed with MS
> Access.  I have tested this myself.  Open Office immediately closed
> (probably crashed) when I tried to open the file with its 'Base'
> program.  I need a library that can help me load that same data into
my
> application.  It does not help me to view the data in MS Access or
other
> applications.
What language is your application written in? You may be able to use the
ODBC driver from within that language.

> What do you mean when you say I need a driver?  Are you telling me
that
> SQLite can read the file or not?  If not, do you know of a library
that
> will help me with my task?
An ODBC (Open Database Connectivity) driver lets you read data out of a 
database, without having it's native application. I think that is 
roughly correct. So, no, SQLite won't open the file and won't help you 
until you get the data out of Access format. The only way I know offhand

to do that without exporting it in csv (comma separated values) or 
something, is an ODBC driver.
Hope this helps.
Fred Stephens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-10 Thread Rich Shepard 
On Thu, 10 Apr 2008, Fred J. Stephens wrote:

> But to us former Access users, "database" is quick shorthand.

Fred,

   Access is a joke. At least, that's what my colleagues who must work in the
Microsoft world tell me.

> And I did say later in the post that sqlite is a database engine.

   That's ambiguous.

Rich

-- 
Richard B. Shepard, Ph.D.   |  IntegrityCredibility
Applied Ecosystem Services, Inc.|Innovation
 Voice: 503-667-4517  Fax: 503-667-8863
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-10 Thread Fred J. Stephens 
Rich Shepard wrote:
> On Thu, 10 Apr 2008, Fred J. Stephens wrote:
> 
>> No, SQLite IS a database.
> 
>Er, not so. It's a relational database management system that supports the
> creation of as many different databases as you care to write.
Right. I knew I was going to make a idiot of myself...
But to us former Access users, "database" is quick shorthand.
"SQLite is the most widely deployed SQL database engine in the world."
 From sqlite.org.
And I did say later in the post that sqlite is a database engine.

>Take a look at mdb-tools. It's a library that lets you read Acess data
> (and schema) files so you can move them to SQLite.
Good idea.

Fred Stephens

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-10 Thread Rich Shepard 
On Thu, 10 Apr 2008, Fred J. Stephens wrote:

> No, SQLite IS a database.

   Er, not so. It's a relational database management system that supports the
creation of as many different databases as you care to write.

   Take a look at mdb-tools. It's a library that lets you read Acess data
(and schema) files so you can move them to SQLite.

Rich

-- 
Richard B. Shepard, Ph.D.   |  IntegrityCredibility
Applied Ecosystem Services, Inc.|Innovation
 Voice: 503-667-4517  Fax: 503-667-8863
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-10 Thread Fred J. Stephens 
John Grant wrote:
> @All,
> 
> Thanks for the replies.  I would like to say that I am new to this, and
> I've spent many hours trying to find documentation so that I don't look
> like an idiot on any forums.  :)  With that said, I'm very confused.
No problem, I am probably going to make one out of myself, but I will 
try to help
until more competent advice comes along.

> I guess I was under the impression that SQLite was a library for reading
> databases of various formats. 
No, SQLite IS a database. It can be used to replace others like Access, 
MySQL etc. However, (and I went through this confusion when moving to 
Linux and away from Access) Access is more than a database engine, it 
also a report generator, query creator, form designer, etc.
SQLite is just the database engine (or library or command line tool).
You provide your own code to create the tables, insert data, and work 
with it.

  I have a file that can be viewed with MS
> Access.  I have tested this myself.  Open Office immediately closed
> (probably crashed) when I tried to open the file with its 'Base'
> program.  I need a library that can help me load that same data into my
> application.  It does not help me to view the data in MS Access or other
> applications.
What language is your application written in? You may be able to use the
ODBC driver from within that language.

> What do you mean when you say I need a driver?  Are you telling me that
> SQLite can read the file or not?  If not, do you know of a library that
> will help me with my task?
An ODBC (Open Database Connectivity) driver lets you read data out of a 
database, without having it's native application. I think that is 
roughly correct. So, no, SQLite won't open the file and won't help you 
until you get the data out of Access format. The only way I know offhand 
to do that without exporting it in csv (comma separated values) or 
something, is an ODBC driver.
Hope this helps.
Fred Stephens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-10 Thread John Grant 
@All,

Thanks for the replies.  I would like to say that I am new to this, and
I've spent many hours trying to find documentation so that I don't look
like an idiot on any forums.  :)  With that said, I'm very confused.

I guess I was under the impression that SQLite was a library for reading
databases of various formats.  I have a file that can be viewed with MS
Access.  I have tested this myself.  Open Office immediately closed
(probably crashed) when I tried to open the file with its 'Base'
program.  I need a library that can help me load that same data into my
application.  It does not help me to view the data in MS Access or other
applications.

What do you mean when you say I need a driver?  Are you telling me that
SQLite can read the file or not?  If not, do you know of a library that
will help me with my task?

Thank you for your input,
-John


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Fred J. Stephens
Sent: Thursday, April 10, 2008 2:23 PM
To: Michael Hooker; General Discussion of SQLite Database
Subject: Re: [sqlite] reading MS Access 97 files

Michael Hooker wrote:
> I dare say someone will ask why you don't use Access 97 (or later) to 
> display the file.  It would be the easiest option, after all!  If you
don't 
> have Access try OpenOffice, it's free.
> 
> If you really want to use Sqlite I'd load the file into Access (or 
> OpenOffice), export it as comma or tab delimited text and start from
there. 
> You won't get any pretty colours or text formatting in Sqlite.  And it
may 
> be that the file has all sorts of strange columnar formatting,
formulae and 
> labels that make it unsuitable for transfer to a plain ordinary
database 
> format, where all rows have an equal number of columns, and each
column has 
> the same type of data in it.  Spreadsheets are designed for flexible 
> display, whereas a database is inflexible (but that is often its
strength - 
> you know that column 5 will always be the price of your widget, and
not a 
> label or a formula).   If the Access file has many pages, each page
will 
> have to be exported and turned into a separate table, with any
necessary 
> linking done through your Sqlite SELECT queries.
I'm confused here - are we talking about Access, the database or Excel 
the spreadsheet? You are probably right about the easiest way to get the

data out so he can use it though, except that I don't think OO handles 
Access databases except through the ODBC driver.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-10 Thread Fred J. Stephens 
Michael Hooker wrote:
> I dare say someone will ask why you don't use Access 97 (or later) to 
> display the file.  It would be the easiest option, after all!  If you don't 
> have Access try OpenOffice, it's free.
> 
> If you really want to use Sqlite I'd load the file into Access (or 
> OpenOffice), export it as comma or tab delimited text and start from there. 
> You won't get any pretty colours or text formatting in Sqlite.  And it may 
> be that the file has all sorts of strange columnar formatting, formulae and 
> labels that make it unsuitable for transfer to a plain ordinary database 
> format, where all rows have an equal number of columns, and each column has 
> the same type of data in it.  Spreadsheets are designed for flexible 
> display, whereas a database is inflexible (but that is often its strength - 
> you know that column 5 will always be the price of your widget, and not a 
> label or a formula).   If the Access file has many pages, each page will 
> have to be exported and turned into a separate table, with any necessary 
> linking done through your Sqlite SELECT queries.
I'm confused here - are we talking about Access, the database or Excel 
the spreadsheet? You are probably right about the easiest way to get the 
data out so he can use it though, except that I don't think OO handles 
Access databases except through the ODBC driver.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-10 Thread Michael Hooker 
I dare say someone will ask why you don't use Access 97 (or later) to 
display the file.  It would be the easiest option, after all!  If you don't 
have Access try OpenOffice, it's free.

If you really want to use Sqlite I'd load the file into Access (or 
OpenOffice), export it as comma or tab delimited text and start from there. 
You won't get any pretty colours or text formatting in Sqlite.  And it may 
be that the file has all sorts of strange columnar formatting, formulae and 
labels that make it unsuitable for transfer to a plain ordinary database 
format, where all rows have an equal number of columns, and each column has 
the same type of data in it.  Spreadsheets are designed for flexible 
display, whereas a database is inflexible (but that is often its strength - 
you know that column 5 will always be the price of your widget, and not a 
label or a formula).   If the Access file has many pages, each page will 
have to be exported and turned into a separate table, with any necessary 
linking done through your Sqlite SELECT queries.

Michael Hooker

On 10/04/2008 20:57:03, John Grant ([EMAIL PROTECTED]) wrote:
> Hello,
>
> I'm new to database programming.  I'm trying to display information from
> a file that is said to "use the Access 97 format".  Can SQLite help me?
> If so, where should begin?
>
> Thanks,
>
>
>
> John K. Grant
>
> Systems Technology, Inc.
> 310-644-3887 (X 58)
> [EMAIL PROTECTED]
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] reading MS Access 97 files

2008-04-10 Thread Fred J. Stephens 
John Grant wrote:
> Hello,
> 
> I'm new to database programming.  I'm trying to display information from
> a file that is said to "use the Access 97 format".  Can SQLite help me?
> If so, where should begin?
You probably need an ODBC driver to display the data. I don't think 
SQLite will be any help until you get the data out. Then, you could 
store it in SQLite instead of Access.
There are ODBC drivers available, for use in Open Office I think, and 
others. Try searching for Access +ODBC

Fred Stephens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users