Pedro Janssen
pedro at plex.nl
Fri Nov 7 10:18:52 CST 2008
Hello Gary, Susan and others, The suggestions that you presented are all known by me, that was a to easy question. I see that my explanation wasn't clear enough. I need the line that is present before some lines of text with tabs, as the first column. 31 maart 2008 13.00- 16.45 uur(zomertijd); 12 graden ....... tab 32 tab 13.47 tab etc 31 maart 2008 13.00- 16.45 uur(zomertijd); 12 graden ....... tab 33 tab 14.34 tab etc ....... ....... ...... ........ ........ ......... 5 april 2008 12.30-17.15 uur; 10 graden; half ...................... tab 40 tab 12.45 tab etc 5 april 2008 12.30-17.15 uur; 10 graden; half ...................... tab 41 tab 12.50 tab etc ................... ...............etc I'll hope i am clear enough now Pedro ----- Original Message ----- From: "Gary Kjos" <garykjos at gmail.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Friday, November 07, 2008 2:46 PM Subject: Re: [AccessD] import question > Hi Pedro, > > So you want to skip some of the text lines? And then put everything > else into a single column table? Or I'm not understanding you > correctly. What I do on imports like this is to bring in all the > records and then use a delete query to remove the stuff that you don't > want after it's in there. I often will import into a temp table, do > some cleanup using queries or manual record updating in table view and > then use an append query from the temp table to the data table I > actually want the data in after it's cleaned up. This allows me to > edit out column headings from reports etc. Sometimes it takes a number > of "clean up" queries to eliminate all the odds and ends. > > Gary Kjos > > On Fri, 07 Nov 2008 10:10:01 (MET), pedro at plex.nl <pedro at plex.nl> wrote: >> Dear Group, >> >> i have a txt files like this. >> >> 31 maart 2008 13.00- 16.45 uur(zomertijd); 12 graden; half bewolkt(na >> 15.00 uur geheel bew); W 1-2; lekker weer. >> 32 13.49 13.3 228912-548226 m 48 p >> 33 14.33 20.9 228801-548621 v 62 p; eerste >> vrouwtje >> 34 14.34 21.0 228809-548625 m 43 p(s) >> 35 14.55 228824-548718 m 48 p >> 36 15.20 229054-549070 m 49 p >> 37 15.30 229092-549162 m 42 s >> 38 15.45 228959-549173 m 43 p >> 39 16.12 228858-548662 m 46 p >> 5 april 2008 12.30-17.15 uur; 10 graden; half bewolkt; NW 2-3; lekker >> weer. Al veel hommels; 14 levendb.hagedis en 4 zandhagedis; baltsende >> haviken. >> 40 12.45 229336-549376 m 52 p >> 41 12.50 229334-549401 m 48 p(s) >> 42 12.52 229333-549403 m 49 p >> 43 12.55 229297-549382 m 41 p >> >> >> Is it possible to import this in a table, so that the first sentence (1 >> or 2 lines) are placed in the first column with each record >> (which is:) >> 32 tab 13.47 tab etc >> 33 tab 14.34 tab etc >> >> >> Thanks >> >> Pedro Janssen >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > > > -- > Gary Kjos > garykjos at gmail.com > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >