Having trouble with a file

maic15

Active Member
Joined
Nov 17, 2004
Messages
313
Hi ,

I have the following report in Note pad, this an example of only one record.
MH10.TXT
ABCDEFGHIJ
1DATE 10/01/05 611 NORTH SHOREKLFACC PER 09 P1
2
3----TOTAL--------OTHER-------MEDICARE--#NAME?XIX--#NAME?CROSS----POINT--------POINT-------POINT----
4FREQ REVENUEFREQ REVENUEFREQ REVENUEFREQEVENUEFREQREVENUEVALUE 1VALUE 2VALUE 3
5******************************************************************************************************************************
6611-0007 CVPCATH 14 OR 17000
7CUR 11000
877000000
9IP 11000
1077000000
11OP 00000
1200000000
13YTD 44000
142828000000
15IP 44000
162828000000
17OP 00000
1800000000
19******************************************************************************************************************************
MH10


How Can I convert into a table for Access?

Example:
MH10.TXT
ABCDEFGHIJK
20CDMDecriptionTypeTotal Current FerquencyTotal Current VolumeTotal YTD FrequencyTotal YTD VolumeOther Current FerquencyOther Current VolumeOther YTD FrequencyOther YTD Volume
21611-0007CVP Cath 14 or 17IP1742817428
22611-0007CVP Cath 14 or 17OP00000000
MH10
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
only line of approach to the problem

hihglight only the first column where they are in something like csv format

data(menu)-texttocolumn-
instep 1 choose <delimited> click nexst
instep 2 choose both tab and space and others blank and not ticked
now click finish

try
 

Watch MrExcel Video

Forum statistics

Threads
1,118,035
Messages
5,569,782
Members
412,292
Latest member
The Bear named Joe
Top