RE: [SLUG] MS access file convert to text file

2003-01-23 Thread Ken Foskey
On Thu, 2003-01-23 at 16:03, Dave Airlie wrote:
 OO doesn't come with database I don't think.. StarOffice does..
 
 Dave.
 
 On Thu, 23 Jan 2003, Rowling, Jill wrote:
 
  Don't know, but you may be able to open it with Open Office's database then
  save it as something else.


OpenOffice.org comes with database access but not with a database
server.

Unfortunately I don't know the capabilities.

-- 
Thanks
KenF
OpenOffice.org developer

-- 
SLUG - Sydney Linux User's Group - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



RE: [SLUG] MS access file convert to text file

2003-01-23 Thread Phil Scarratt
Quoting Ken Foskey [EMAIL PROTECTED]:

 On Thu, 2003-01-23 at 16:03, Dave Airlie wrote:
  OO doesn't come with database I don't think.. StarOffice does..
  
  Dave.
  
  On Thu, 23 Jan 2003, Rowling, Jill wrote:
  
   Don't know, but you may be able to open it with Open Office's database
 then
   save it as something else.
 
 
 OpenOffice.org comes with database access but not with a database
 server.
 
 Unfortunately I don't know the capabilities.
 

Actually the only difference I can tell between StarOffice and OO db wise is
that StarOffice comes with a limited licence for Adabas engine. Apart from that
it appears you can pretty much do whatever you can do in Access...


Fil

-- 
Phil Scarratt
IT Consultant
0403 531 271

-- 
SLUG - Sydney Linux User's Group - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



RE: [SLUG] MS access file convert to text file

2003-01-22 Thread Rowling, Jill
Don't know, but you may be able to open it with Open Office's database then
save it as something else.

-- 
Jill Rowling, System Administrator
Eng. Systems Dept, Aristocrat Technologies Australia
Level 2, 55 Mentmore Ave Rosebery NSW 2018
Phone: (02) 9697-4484 Fax: (02) 9663-1412 Email: [EMAIL PROTECTED]
 


-Original Message-
From: Kevin Saenz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 23 January 2003 15:28
To: [EMAIL PROTECTED]
Subject: [SLUG] MS access file convert to text file


Hi all,

I have been sent a MS access file and I can't read
it can i convert it to .sql ?

thanks

-- 
Kevin Saenz [EMAIL PROTECTED]

-- 
SLUG - Sydney Linux User's Group - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug

--
IMPORTANT NOTICES
This email (including any documents referred to in, or attached, to this
email) may contain information that is personal, confidential or the subject
of copyright or other proprietary rights in favour of Aristocrat, its
affiliates or third parties. This email is intended only for the named
addressee. Any privacy, confidence, copyright or other proprietary rights in
favour of Aristocrat, its affiliates or third parties, is not lost because
this email was sent to you by mistake.

If you received this email by mistake you should: (i) not copy, disclose,
distribute or otherwise use it, or its contents, without the consent of
Aristocrat or the owner of the relevant rights; (ii) let us know of the
mistake by reply email or by telephone (+61 2 9413 6300); and (iii) delete
it from your system and destroy all copies.

Any personal information contained in this email must be handled in
accordance with applicable privacy laws.

Electronic and internet communications can be interfered with or affected by
viruses and other defects. As a result, such communications may not be
successfully received or, if received, may cause interference with the
integrity of receiving, processing or related systems (including hardware,
software and data or information on, or using, that hardware or software).
Aristocrat gives no assurances in relation to these matters.

If you have any doubts about the veracity or integrity of any electronic
communication we appear to have sent you, please call +61 2 9413 6300 for
clarification.
-- 
SLUG - Sydney Linux User's Group - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] MS access file convert to text file

2003-01-22 Thread mlh
On Thu, Jan 23, 2003 at 03:27:45PM +1100, Kevin Saenz wrote:
 I have been sent a MS access file and I can't read
 it can i convert it to .sql ?

http://mdbtools.sourceforge.net/

Matt
-- 
SLUG - Sydney Linux User's Group - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



RE: [SLUG] MS access file convert to text file

2003-01-22 Thread Dave Airlie

OO doesn't come with database I don't think.. StarOffice does..

Dave.

On Thu, 23 Jan 2003, Rowling, Jill wrote:

 Don't know, but you may be able to open it with Open Office's database then
 save it as something else.



-- 
David Airlie, Software Engineer
http://www.skynet.ie/~airlied / [EMAIL PROTECTED]
pam_smb / Linux DecStation / Linux VAX / ILUG person


-- 
SLUG - Sydney Linux User's Group - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] MS access file convert to text file

2003-01-22 Thread Matthew Palmer
On 23 Jan 2003, Kevin Saenz wrote:

 I have been sent a MS access file and I can't read
 it can i convert it to .sql ?

I've got VBA code to extract all the data out of an Access DB.  However, it
needs Access to run (I've got it going under Access 97, but it's pretty
general) and takes time.  Remember, also, that the tables are typically only
a smallish part of a full Access DB, and I doubt most of the rest of it will
be easily convertable by anything.  Of course, if you do find something,
please let me know - I'm currently rewriting the Access DB from hell in
something sensible...


-- 
---
#include disclaimer.h
Matthew Palmer, Geek In Residence
http://ieee.uow.edu.au/~mjp16


-- 
SLUG - Sydney Linux User's Group - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] MS access file convert to text file

2003-01-22 Thread Jeff Waugh
quote who=Matthew Palmer

 On 23 Jan 2003, Kevin Saenz wrote:
 
  I have been sent a MS access file and I can't read
  it can i convert it to .sql ?
 
 I've got VBA code to extract all the data out of an Access DB.

You guys might be interested in mdbtools.sf.net - there's now a GNOME
frontend, and a backend for gnome-db (for use with Mergeant).

- Jeff

-- 
How was the opera?
 The seats were very comfortable. 
-- 
SLUG - Sydney Linux User's Group - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug