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]
