text/csv is usually the best bet. It can usually be imported into any
db. If you decide to use postgresql, I can probably help. I have been
importing text/csv files into postresql a lot lately. I use postgresql
and OOo on both WinXP and Ubuntu linux.
Tim
Dinbandhu wrote:
On Tue, 2007-09-25 at 10:17 -0400, Andrew Jensen wrote:
Swarup,
WOW
You have Access 2003, correct.
Start Access and open your file.
File > Export
Pick some file based export.
Export your data.
I have MS Access 2000.
When I open my file, and go to File > Export, there are a variety of
options as you know.
You said it should be "file based".
There in the options list, I see:
Text Files
Rich Text Format
ODBC Databases
HTML Documents
Would any of the above be good?
Once I do the above export, then to bring it into Linux OO Base will I
be doing a copy and paste, or is it instead an actual "import"
procedure? Will it involve the "connect to an existing database" option
in Base?
Thanks,
Swarup
On 9/25/07, Dinbandhu <[EMAIL PROTECTED]> wrote:
On Tue, 2007-09-25 at 09:34 -0400, Andrew Jensen wrote:
Hi Swarup,
Yes, the same people that asked you to upgrade are now telling you
that after doing so the option is no longer available to do what it is
you actually wanted to do, in the way you actually wanted to do it.
I was one of those people and I apologize.
What Mechtilde means, I think, is that since OO.org is free you could
always put a copy under windows, migrate your data to Base there, then
copy the Base file from the XP formatted partition to the Linux
formatted partition.
As Mechtilde has just explained, he actually refers to an external HSQL
DB, rather than the internal one. He recommended MySQL or Postgresql or
Oracle.
So what would be the best, simplest, most straight forward way of
proceeding here? My databases are not complex, I just need to import
them in some simple clean way. I could easily download and install the
OO 2.3 for Windows if that works well. Or I could try using one of the
external HSQL formats if someone explains how it is done (or if there is
a good HowTo somewhere).
Or failing all that, I will just have to install OO 2.2 on the computer.
If nothing else, I know quite well at this point how to do the import
that way. I could do all my imports using OO 2.2, then when they're
imported, replace 2.2 with 2.3 so I can use 2.3's Forms Wizard. This is
a bit of a convoluted approach, but I least I now how to do it.
I would rather use either Windows OO 2.3 or an external HSQL DB if they
would work well and there is some clear explanation available as to how
to do it.
Thank you,
Regards,
Swarup
On 9/25/07, Dinbandhu <[EMAIL PROTECTED]> wrote:
On Tue, 2007-09-25 at 15:22 +0200, Mechtilde wrote:
Frank Schönheit - Sun Microsystems Germany schrieb:
Hello Swarup,
I am trying to "connect to an existing database" using OO 2.3 Base
(OS=Linux Ubuntu). The existing database is an MSA database in my
windows partition.
Debian-based distributions contained an experimental Linux-driver for
.mdb files, but this driver has been removed in their 2.3 version.
Which, as sorry as this might be, is correct as the driver was pretty
flawed and effectively a danger to your data.
I can confirm this. You can do the connection under Windows to migrate
your database to a free (as freespeech) database management system.
Could you explain a little more? What do I need to do to import my MSA
files. To what free database management system do you refer?
Thanks,
Swarup
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
