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]
