Horizontal DB convert

[williamtak]

Hello guys!
I am a novice access user, and would like to convert a database from the horizontal to a access db.

This is bd.

1NONONO 66.742.159/0001-20501005363RIBEIRO DE SOUZA 11/2010 ANALISTA PATRIMONIAL 000000002000.43MES0012017 100048 01122010 0, 14/12/2010 03/12/20100001.000.3.01.0001ADM. LOCAL
20001SALARIO 000000000030,0000000001.500,43000000000000000
20082HORA EXTRA 50% 000000000005,73000000000058,65000000000000000
20087REFLEXO DSR 000000000000,00000000000017,85000000000000000
20003I.N.S.S. 000000000009,00000000000000000000000000141,92
20006VALE TRANSPORTE 000000000000,00000000000000000000000000090,03
20019ADIANTAMENTO DE SALARIO 000000000000,00000000000000000000000000600,17
20100VALE ALIMENTAÇAO 000000000000,00000000000000000000000000009,86
20103SEGURO DE VIDA 000000000000,00000000000000000000000000007,00
20200CONTRIBUICAO ASSISTENCIAL 000000000000,00000000000000000000000000015,00
20274REFEICAO 000000000000,00000000000000000000000000012,50
300000001.576,93000000000876,48000000000700,450000 00001576.93000000001576.93000000000126,15000000000 976.76
4

Note that the comic starts with a number on each line (1,2,3,4), that identifies the group.
It is a comic a little tricky, I'll try to explain ...

LINE 1 # #

1NONONO 66.742.159/0001-20501005363RIBEIRO DE SOUZA 11/2010 ANALISTA PATRIMONIAL 000000002000.43MES0012017 100048 01122010 0, 14/12/2010 03/12/20100001.000.3.01.0001ADM. LOCAL
_______________________________________________

COMM = Must be in one column
66.742.156/0001-20 = new column


501005201 = new column
RIBEIRO SOUZA = new column
000000002000.43 = new column
MES = NEW COLUMN
001 = NEW COLUMN

And so on.

#######################3

LINE 2 # #

0001SALARIO 000000000030,0000000001.500,43000000000000000
_______________________________________________

0001 = column
SALARY = column
= 000000000030.00 cokuna
00000001.500,43 = column
000000000000000 = column

Help me, please!

Sorry for a bad English

[weekend00]

What a mess.

I even don't know where is line 1, line 2...

are your data in fix width columns?

[pkstormy]

I used to write code to import/export data like this from Fannie Mae. If I recall, I didn't import it normally (ie. docmd.transfertext...) but instead used code like: Line and Input #. And then wrote code to walk through the line, filtering out the characters and saving them to the appropriate fields in my table. It's not the easiest to do but is doable.