On 02/12/2008 11:09 AM, John Jason Jordan wrote: > On Tue, 12 Feb 2008 22:02:51 +0300 > Kirill Palagin <[EMAIL PROTECTED]> dijo: > >> John Jason Jordan пишет: >> > On Mon, 11 Feb 2008 08:05:29 +0300 >> > Kirill Palagin <[EMAIL PROTECTED]> dijo: >> > >> > >> >> File - New - Database- Connect to an existing DB-Text-Next - Browse to >> >> your csv. >> >> >> > >> > Unfortunately, when I browse to the .csv file the file is grayed out. >> > >> I guess this is the way it works - you do not select the file, but the >> folder with your .csv and when wizard completes you get all your txt >> files as tables. > > Doesn't work. I can't find any way to get the .csv file into Base. I > created a new database in Base, then went to Open, but when I selected > the .csv file OOo opened it in Calc, not Base. > > Can you give a step by step for how you did it? Like, starting from > launching the app (e.g., did you launch Base, Calc, what?). Then > exactly what did you do next? E.g., if in Base, did you click Create > New Database, Open Existing Database, or what?
With the .csv open in Calc and an opened Base file: 1. In Calc select the all data (including headers) and copy. 2. In Base select the Tables icon, now in the lower right "Tables" pane, right-click and select 'Past Special' - select Formated text [RTF]. That will open up a panel for selecting a Table name etc., follow the prompts. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
