Tnx for the reply Allen, I have commented in line. 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. ____________________________________________________________________________________ >>> Allen <[EMAIL PROTECTED]> 2007/11/09 01:27 pm >>> 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 imprt 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? Ah, yes. Been there, done that except with 450Mb of data in versions of Paradox, Excel, & Access so you are three steps ahead of me. :) How come I always feel 3 steps behind The steps are: 1) Set your options for OOo to display paragraph returns and spaces. 2) Open your file in OOo Writer. 3) Examine every line and make sure that the paragraph marker is there - add them where needed. 4) Search for and replace semicolons with commas. (I might actually search and replace the semicolon with a command a space. Sometimes this can be helpful. 5) Search for and replace all double spaces with a single space. This take more than one pass to get them all. 6) Save the file as a .txt file. 7) Import into Base. Allen, I already have a comma separated value(csv) text file of the data that I can open in Calc and it displays in the right columns. I did not separate the fields with a comma as some urls have a comma in them. I used a semicolon instead as I have not seen that used....yet. My problem is IMPORTING the data csv file into the database ie where do I find a 'Get external data' or 'Import/Export ...' , and must I have the table open, closed, selected etc? Considering I only have a single line in my database table, I cannot copy and paste from Calc to Base. 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]
