On Tue, 2007-09-25 at 15:18 -0400, Andrew Jensen wrote: > 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.
Wonderful! That sounds very do-able. Thank you so much. I didn't realize it could be so simple. Such a complex process I went through to manage the import via Calc in OO 2.2. Is the result going to be the same as what I did there, insofar as it being a standard Base table? > If you need to edit the data it is a little different. I will be needing to add new rows to the table. And on occasion I will need to change some data in the pre-existing rows. Is that going to be do-able? If you could just explain briefly what you mean by "a little different". Many thanks, Swarup > > 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] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
