Gary Kjos
garykjos at gmail.com
Fri Nov 7 11:14:23 CST 2008
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