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.
>
> If you need to edit the data it is a little different.
I have tried this several times, but what I get when I open the Base
file and click on "table", is not a table but rather that text file with
all the fields separated by commas.
When I select 'Connect to existing databse...' and select "TEXT" from
the drop down listbox, then in the next window it asks whether the file
is of type "text (.txt)", or "CSV (.csv)". There, if I select "text"
then I get the result described above. And if I select "csv" then the
database is created with nothing in it.
The file which I export from MS Access does have as its suffix, ".txt".
In the MSA export window, there is no "csv" option as such. There is
only "txt". In the MSA export wizard, you select to export as "Text
Files". Then in the next window it asks you whether you want the export
format as "Delimited (Characters such as comma separate each field)", or
"Fixed width (Fields are aligned in columns with spaces between each
field)". I selected "Delimited". Then it asks to choose the delimiter
that will separate the fields-- so I selected "comma". And the "Text
qualifier", I let remain as the default ("). Having selected these
parameters, the file is then exported as type ".txt". So I could not
figure any way for it to export with type ".csv".
Have I made some error in the above-described process?
Swarup
> 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]
