Import tab delimited text file with header rows


H

Hugh self taught

Hi All,

Here is a sample portion of my text file. I'm looking for suggestions on how
to import this into a temp table. I need all the info (except the blank lines
Duh..Heh..)

The very first line is the Competition name. I'm sure you can figure out
what the rest is.

Test - Ballroom & Latin Festival - 24/05/08

1. ADULT BEGINNER BALLROOM (W/Q) (final)

94 T KORZENIEVSKI & M FRANK
253 E HEYNS & T GUNTHER
11 J ADAMS & T GELLARD
35 C HOLMES & R MALAN
69 S VAN DER KOLFF & M DE JAGER
70 C VAN DER MERWE & E VAN DER MERWE
115 D THOMPSON & D COWELL

4. YOUTH BRONZE BALLROOM (W/Q) (semi final)

11 J ADAMS & T GELLARD
35 C HOLMES & R MALAN
69 S VAN DER KOLFF & M DE JAGER
70 C VAN DER MERWE & E VAN DER MERWE
115 D THOMPSON & D COWELL
121 J VAN ROOYEN & A DE COSTA

5. ADULT BRONZE BALLROOM (W,Q) (semi final)

33 M HERHOLDT & K BEHMER
36 N JARDIM & M DA SILVA
80 R CAMPBELL & N EASTWOOD

In my file there are other blank tabbed fields not shown here which I can
deal with later.

Any help is greatly appreciated.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top