OK- good, CSV is a good enough choice. The real question now is. Just how similar are those different MSA database tables.
If they are real close in structure then using a linked TEXT table in your Base file works very well and I can walk you through doing that - the actual HSQLdb manual gives you the syntax and there are a some good examples of using Base with it. Speaking of which you don't read French by any chance do you? On 9/25/07, Dinbandhu <[EMAIL PROTECTED]> wrote: > On Tue, 2007-09-25 at 08:53 -0600, Tim wrote: > > 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. > > Thank you. That would be great. > > I'll use whatever you think best. > > I just went into the MSA file in Windows, selected the table I want to > export, and exported it as type "Text Files". I selected "comma" as the > separator, and the export went fine. It is now a "Text Document" sitting > on my XP desktop. > > So if I now boot up into Ubuntu and open OO Base, then what will be the > procedure for bringing this table into Base from my XP desktop? > > Thanks, > Swarup > > > > > > > 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] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
