Ah, if you haven't needed IM up till now - maybe no reason to make you get it now..Let's try to finish this here and now. If you have the time, I have the time then.
You have exported your table from MS Access as a TEXT file, with default settings. You switch to Linux and tried to create a Base TEXT data source to read that and all of the fields come in as one long concated string in the new table - single field in other words. BUT didn't you say you wanted to edit that data once it was in Base..that is correct isn't it? So, the simple text data source is not going to work. You really do want to import the data to Base, or link it in as a TEXT table. Did you say what the table structure was in MS Access. I don't suppose you know how to run have Access generate a data dictionary file by any chance. It' in there but I don't recall how either. If we had that I'd just give you back the statement to create the TEXT table link. Ha - got it. Go back in windows. Make a Copy of that MDB file and in the copy delete all the records from the tables, so they are blank. OK. Then send me a direct email at [EMAIL PROTECTED] and attach that emptied MDB file to the email. I'll give you back a very simple script that will create the link for you...Can you do that for me? On 9/27/07, Dinbandhu <[EMAIL PROTECTED]> wrote: > I am sorry Drew, I do not know what "IM client" means-- which probably > means I do not have one. But I know people set such real-time mechanisms > up free all the time. If you tell me such a site to go to, I'll set one > up for myself now. I think Yahoo has something like that, don't they? > > Swarup > > > On Thu, 2007-09-27 at 13:02 -0400, Andrew Jensen wrote: > > ROFL... > > > > OK - tell you what. Do you have an IM client? > > > > If so, we can get on-line in about 30 minutes from now and I'll try > > and walk you through it..really you are just missing a couple of > > really simple steps. Problem is I don't have MS Access on any machines > > any more and I can't remember the actual layout of that file. But if > > we could talk in Real Time it should only take a couple of minutes. > > > > On 9/27/07, Dinbandhu <[EMAIL PROTECTED]> wrote: > > > On Thu, 2007-09-27 at 12:44 -0400, Andrew Jensen wrote: > > > > Swarup, > > > > > > > > Sorry, you got lost in the switches there. > > > > > > > > I think I mentioned this before, but if not. > > > > > > > > http://www.oooforumorg.org > > > > > > > > Go to the Base section and post a question > > > > How to import CSV file to Base > > > > > > > > There are currently three individuals working that board that I > > > > guarantee will get you up and running. > > > > > > Alright, I'll try that. Thank you. > > > > > > When I first started my Base queries I had gone there-- but you were the > > > only one who replied to me there. And you wrote that you weren't going > > > to be replying any more there, and I should join the [dba-users] list > > > and post my query there. That is why I came over to this list. > > > > > > Swarup > > > > > > > > > > > > > On 9/27/07, Dinbandhu <[EMAIL PROTECTED]> wrote: > > > > > If this is not the right forum for solving the issues I face, please > > > > > refer me to the right one and I'll certainly take my queries there. > > > > > > > > > > Thanks, > > > > > Swarup > > > > > > > > > > On Thu, 2007-09-27 at 09:32 -0400, Dinbandhu wrote: > > > > > > 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] > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > 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] > >
