Pedro Janssen
pedro at plex.nl
Sun Nov 9 06:05:44 CST 2008
Hello Gary en Gustav, thanks for your solution, i will try to make this work for my situation. Best Wishes 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 6:14 PM Subject: Re: [AccessD] import question > Oh, I see now. I beleive you will need to write text reading code in > order to do this. It's not that hard, I've done it, but not for years. > One of our founding members has posted some VB code for doing text > file I/O on his website > > http://seth.galitzer.net/node/11 > > Look for "File I/O in VB" > > There are also outside utility programs that can do this type of > thing. I used to use one many years ago but have forgotten the > name...If it comes to me I will post again. I think writing a VB > import routine where you read the data character by character is what > you will need to do though. > > GK > > On 11/7/08, Pedro Janssen <pedro at plex.nl> wrote: >> 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 >> > >> >> -- >> 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 >