Hello, On Wed, 17 Sep 2003 09:01:08 +0530, Sthitaprajna wrote: >On Tue, 16 Sep 2003 23:20:34 +0530, "Narayana" <[EMAIL PROTECTED]> >said: > >>Can anyone tell me as to how I can import a Dbase database table >>into >>MySQL database. >>The original database is in Access. As I did not want to continue >>with access, I could export the table to a Excel sheet. Using >>Openoffice Calc I opened this "xls" file and exported it into a DBF >>file. > >http://groups.google.com/groups?q=%22MS+Access%22+mysql+port&hl=en&lr >=&ie=UTF-8&selm=Tmia6.4077%24vH6.78368%40news6- >win.server.ntlworld.com&rnum=4 > >http://dbf2mysql.sourceforge.net/
Thanks a lot. By the time I looked at this email in the evening, I managed to get that done using Openoffice only. BUT, I am now facing another problem. Before that, please excuse me if I sound very silly, as I said before that I am new to Database tech. ALso I have to do the job in just 3 more days. The problem is this: I have a 500 odd address book records and another 5000 record table, both with badly designed columns. I wanted to change the columns into something more meaningful. So I first imported the whole database table into MySQL. Now I intend to merge some of the columns into a single column. I am not sure How to go about doing it. After the merge, I intend to delete the other columns. I also have to do the opposite. There are too many details in a single column. I have to split that into multiple columns. This enables me to generate reports in a proper way. May be I have to manually create more tables and split it up. But I am wondering whether shortcuts exist. Maybe some pointers would help. Call it normalization or whatever.. Yet another problem I am wrestling is to produce reports. The reports should preferably be either a csv file, or an excel file or an open Calc file, so that I can manipulate them easily. I have never used any professional report tools like crystal reports. The report writing capability of Openoffice is somewhat disappointing for me, although the data entry forms are very good. So please suggest me some report generators either in windows or linux. In the meanwhile I will be wrestling..!! Thanks in advance, Regards, Narayana. ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
