The way I extracted my data was to right-click on each table and copy, and then open a new spreadsheet and paste. Once in the spreadsheet you can then save as CSV for easy importing into MYSQL.
On 6 November 2012 10:10, Ian Whitfield <[email protected]> wrote: > On 11/06/2012 11:34 AM, Pertti Rönnberg wrote: > >> Hello LibO experts, >> and congratulations IanW! >> >> It has been very interesting to follow this discussion getting Base >> working with MySQL. >> Unfortunately -- if I got it right - is Ian's OS a Linux (Ubuntu?) >> >> Would it be possible to get the same proceeding described as a >> step-by-step instruction for Windows7 (64bit)? >> > in plain english (no IT-jargong) >> > starting from the very beginning defining the different programs >> (versions) and components (ODBC, JDBC, JRE, etc when needed, included) to >> be installed >> > > Hi Pertti > > Noted on your comments!! Unfortunately I'm running PCLinuxOS here and NOT > Windows!! (I'm sure you will be told to move by someone!!). So I don't > think it's any use me sending you the steps I went through. I did however > have the same situation here and over the past 8 months or so this was the > fourth attempt at getting it working. > > In the past I gave up after several days of "thrashing" about and went > back to Base/HSQL until it crashed on me again and so on and so on.... > > This time I decided to hold out and work it through to the very end!! > There were many things to learn and lots of Hoops to jump through but we > got there in the end thanks to the aforementioned Members of the Forum > (thanks again Guys!!) > > I'm sure somebody WILL pop up and try and help you out - just stay with > it, one step at a time, and you'll get there in the end. > > VERY early days here but so far it looks good and I have a good feeling > about Base/MySQL. I'm stuck at the moment though trying to extract my data > from the old DB!!! Whatever I try it just crashes on me..... (Grrrrrrr). > > The saga continues and I will be VERY glad to be shot of Base/HSQL!!! > > All the best > > IanW > Pretoria RSA. > > -- > For unsubscribe instructions e-mail to: [email protected].** > org <users%[email protected]> > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: http://wiki.**documentfoundation.org/** > Netiquette <http://wiki.documentfoundation.org/Netiquette> > List archive: > http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> > All messages sent to this list will be publicly archived and cannot be > deleted > > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
