Well, if all you really want to do is query it. Copy it to a directory within your Linux partition ( not absolutely necessary ) From OO.org create a new Base file. Instead of a default type select 'Connect to existing database..' and select TEXT from the drop down listbox.
Follow the instructions and where asked for select the directory where the file is located. When you open the Base file the file will appear as a table. If you need to edit the data it is a little different. Drew On 9/25/07, Dinbandhu <[EMAIL PROTECTED]> wrote: > On Tue, 2007-09-25 at 15:02 -0400, Andrew Jensen wrote: > > Wonderful then, > > > > I am sorry that I got caught up with D&D and all that malarkey before, > > forgetting to look at the best way to get the job done with the tool. > > > > Best of luck with your work > > > > Drew > > > Wait-- give me a hint at least, what is the procedure for bringing this > CSV file into linux OO Base? > > Is it a copy and paste? If so, into what window? > Is there an import wizard for it? > > --not sure what you mean by D&D, what you have taught me so far has been > invaluable. > > Swarup > > > > > > > On 9/25/07, Dinbandhu <[EMAIL PROTECTED]> wrote: > > > 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] > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
