Guys, thanks, The mail of Regina solved it for me. I stupidly didn't think of opening the database in a separate window but tried to do it on the view, displayed when using view -> datasources. I now have a table with addresses and I can use SQl to extract what I want. Thanks again Joep
On Wed, 2005-11-30 at 09:26 +0100, Axel Hoernke wrote: > J.L. Blom schrieb: > > Hi, > > It's maybe requested more but I can't find how to convert - or import - > > a spreadsheet (or document table) into a database table. > > I have an address list made in an MSword table. I can convert it to a > > spreadsheet but I cannot find how to import it in a database (native OO) > > or (better) transform it into a database table. > > Can anybody give me a direction how to perform it? > > Thanks, > > Joep > > Hi Joep > > I hope I understand your problem in a right way and the following steps > can help: > 1. Start Base > 2. In the first step of the wizard choose "Connect to an existing > database" (e.g. in your case 'spreadsheet') > 3. in the "Browse"-dialogue choose your spreadsheet-file in the > directory where do you saved your spreadsheet, then click "Next" > 4. the otions in step 3 are ok, click 'next', your spreadsheet is now a > available datasource in ooo (read-only! to make it writable, pick the > table and copy it in a HSQL-Database (e.g. per Drag'n'Drop') > > hth > Regards from Germany, > Axel > > > > > --------------------------------------------------------------------- > 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]
