Susan Harkins
ssharkins at gmail.com
Fri Nov 7 08:37:22 CST 2008
The Import Wizard will let you skip columns and it will let you skip or import the first row to use as headings or not. I don't know if that helps you or not. Susan H. > 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