Hello Drew, See replies below. On Thu, 2007-08-30 at 23:37 -0400, Andrew Jensen wrote: > Hello Dinbandhu, > > Well, I can be very slow sometimes so if you don't mind let me try to recap. > > You have an Access 97 database, correct? ( I assume this since you mentioned > Win98 ) > > You do no have a Windows version of Base, that is only on your Ubuntu > installations, correct? > > When you run Base under Ubuntu you are offered the option to connect to an > external database of type MS Access, correct? ( I believe this means you > have the community build of the OO.o application ) > > You can open the Access97 database directly with a Base file and see the > data, but the columns are in the wrong order. ( 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 ) > > 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? > > 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. > > Also - you said you exported the data to a csv file. In this file is the > data correct?
I tried exporting the data from MSA in two formats; one in .csv format (which in Windows is an Excel file), and the other as I just left as a "text" file without appending the .csv during export. This letter file remained a text file and in Windows opens in Notepad. The .csv file does look accurate, except for two things: (1) The date/time columns are just all # signs. Each cell in the date/time columns looks like this: #####. (2) The yes/no (boolean) column is converted into 0 or 1 in each cell. The "text" file on the other hand, does seem to have all the information intact. > 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? When go to Base and launch the 'Connect to existing database', and 'TEXT' and then browse to the Windows desktop where the above-mentioned .csv and text files are located, I see that those two as well as virtually everything else (except one unrelated folder), is grayed out. So I could not select either the .csv or the text file to connect to. What should I do next? Regards, Swarup --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
