[AccessD] import question

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
> 




More information about the AccessD mailing list