On Fri, 2007-08-31 at 15:25 +0200, Mechtilde wrote: > Hello > > Dinbandhu schrieb: > > Hello Drew, > > > > Actually, I have Office 2000 loaded on this machine. So it is not Access > > 97, but rather than next one after that. Is it called Access 2000? I > > forget the name now. And that is also the same MS Access which I have on > > my XP machine. So on both machines we are going from MS Access (the one > > in Office 2000) to Ubuntu Feisty OO Base. > > > >> You do no have a Windows version of Base, that is only on your Ubuntu > >> installations, correct? > > > > Correct. > > > >> When you run Base under Ubuntu you are offered the option to connect to an > >> external database of type MS Access, correct? > > > > Correct. > > > >> ( I believe this means you > >> have the community build of the OO.o application ) > > The Comunity version doesn't have the option to connect to an Access > database because it's bleeding edge. > > > > > ok. I can tell you that OO came with the Ubuntu installation. There may > > have been updates that came into the computer in the natural course, but > > the original version was installed by the Ubuntu live cd. > > > >> You can open the Access97 database directly with a Base file and see the > >> data, but the columns are in the wrong order. > This is no more possible > > so you have to install OpenOffice.org on your win maschine. There you > can connect to MS Access. > There you can do the following things.
But it does seem to be working just fine through ubuntu Base. When I open Base, it does give me the option to connect to a pre-existing database. And when I select MSA and browse to the Windows partition, it opens the database just fine. As I say, the columns are in the wrong order. But perhaps that is because of what Drew suggested-- that Base does not deal with the "presentation view". Still though, it will be quite important for me to get the columns in proper order. In MSA it used to be a pain in the neck to have to move columns around. Unless it is a lot easier in Base, I'd prefer to have some better way to bring the table in so the columns are in the order of the MSA's presentation view. > > > >> ( This may be misleading. > >> Access allows you rearrange the presentation view of the table, but this > >> does not change the physical order of the fields in the actual table. When > >> Base opens the table it is not aware of these presentation view settings > >> and > >> therefore displays the fields in the table in the natural order. At least > >> this is what I believe is happening, but could be wrong ) > > > > I don't know. To some extent it appears to be the chronological order in > > which the columns were added. Because just a few days ago I added four > > or five new columns-- but when I added them I inserted them near the > > left side of the table. But in Base, they appear all the way to the > > extreme right. > > > >> There are two datetime fields in the Access database, but the copy table > >> wizard marked them as being something else. Was it varchar by any chance? > > > > I think it may have been. If that is important, I'll go through the > > process again to confirm. > > > > > >> You changed these to datetime in the wizard and they came over ( those > >> that did ) as 01/01/70 12:00 Am > > > > Correct. > > > > > >> You changed these to datetime in the wizard and they came over ( those > >> that did ) as 01/01/70 12:00 Am, which is the NOT A DATE, date for > >> Access97. > > > > See just here below, > > > >> , which is the NOT A DATE, date for Access97. > > > > I'm not sure what you mean by this. the date "01/01/70 12:00 Am" is not > > one of the dates in my table. There is no date 1/1/70 in the table. Is > > that what you are wanting to confirm here? > > > >> Also - you said you exported the data to a csv file. In this file is the > >> data correct? > > > > I opened the csv file last night, and on quick glance it looked like > > everything was there. But I did not look at it carefully by any means to > > confirm the accuracy of the data. After sending this note to you, I will > > check that I write you again with the answer. > > > >> Now, if it is you could also do this. Start Linux and create a new Base > >> file. In the new file wizard select 'Connect to existing database' again, > >> but this time of type TEXT. On the second screen of the wizard you select > >> the directory where the csv file is located. When the Base file is opened > >> the csv file will appear as a table. If you do this, is the data correct? > > > > I will do this as soon as I send this to you, and let you know shortly. > > > >> One final thing - If this is test data, or data that is not sensitive you > >> could email me the file and I can try to import them to Base under a > >> Windows > >> version of OO.o. If there is no problem then I'll send the Base file back. > > > > Unfortunately, the data is a bit sensitive. But perhaps even more an > > issue here, is that I have several data bases I need to import. So it > > behooves me to know how to do it. > > > >> Meanwhile I'll wait on your answer. I am going to be up and online for a > >> little while still. > > > Regards > > > Mechtilde > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
