Brian, Hylton Conacher Assistant Computer Lab Administrator Green Lab Student Computing Services Information and Communication Technology Services University of Cape Town Email: [EMAIL PROTECTED] Web: http://www.icts.uct.ac.za
____________________________________________________________________________________ This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 4500. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity. ____________________________________________________________________________________ >>> Brian Barker <[EMAIL PROTECTED]> 2007/11/09 01:50 pm >>> At 11:54 09/11/2007 +0200, Hylton Conacher wrote: >I am creating a new Base database for my collection of 20 odd >thousand URL's and sites of interest. I am however having a problem >in importing or placing the data, that is in a csv file, into the database. > >My csv data is separated by semicolons and is in three columns >namely ID, Description, URL. >I created a table in design view with the above columns but have so >far been unable to import data! >I am using OOo.org 2.0. > >How can I import the data as there is no chance I am re-entering 20 >000 bookmarks? o Go to File | New > | Database to create a new database. o In the first panel of the wizard, select "Connect to an existing database" and then Text from the drop-down menu. o In the second panel, select "'Comma separated value' files (*.csv)" and ensure "Field separator" is correct. o Select Browse and navigate to the folder containing your .csv file. o Complete the wizard, giving the new database a name and saving it. o Select Tables in the left panel and you should see a table corresponding to your .csv data in the lower panel. I trust this helps. TNX You are a genius :). It worked perfectly, although I am going to have to make sure there is only one csv file in the directory I am importing from. Would be nice to be able to select the file as opposed to only the directory, but I can live without it, for a while. :) Regards Hylton ____________________________________________________________________________________________________ This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 4500. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity. ____________________________________________________________________________________________________ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
