On Tue, 2007-09-25 at 14:00 -0400, Andrew Jensen wrote: > OK- good, CSV is a good enough choice. > > The real question now is. Just how similar are those different MSA > database tables.
Actually, the job is going to be simpler than you think. I only have one table in the database. It is a largish table--in comparison with most of what I do in a database--as it has around 5000 rows. The table is an address list. Each row represents a recipient of our newsletter, i.e. an addressee. And there are around 25 columns. The columns are mostly of type text, but there are several columns which are of type date, and there are some boolean columns as well. There are several queries that I use with that table, but those I can deal with afterward. I will either bring the queries in using the SQL export you pointed out to me if it works smoothly, or I'll recreate the queries in base from scratch. > 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? I don't read French well enough to learn from a technical document, unfortunately. But then, I don't think I'll be needing to set up the sort of technical linked Text table to which you refer. Swarup > 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] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
