Having trouble with a file

[maic15]

Hi ,

I have the following report in Note pad, this an example of only one record.

MH10.TXT
	A	B	C	D	E	F	G	H	I	J
1	DATE 10/01/05 61	1 NORTH SH	ORE		KLF				ACC PER 09 P	1
2
3	----TOTAL----	----OTHER----	---MEDICARE--	#NAME?	XIX--	#NAME?	CROSS-	---POINT----	----POINT----	---POINT----
4	FREQ REVENUE	FREQ REVENUE	FREQ REVENUE	FREQ	EVENUE	FREQ	REVENUE	VALUE 1	VALUE 2	VALUE 3
5	*****************	***************	****************	*******	******	*******	*********	*********************	***************	*************
6	611-0007 CVP	CATH 14 OR 17						0	0	0
7	CUR 1	1	0		0		0
8	7	7	0		0		0	0	0	0
9	IP 1	1	0		0		0
10	7	7	0		0		0	0	0	0
11	OP 0	0	0		0		0
12	0	0	0		0		0	0	0	0
13	YTD 4	4	0		0		0
14	28	28	0		0		0	0	0	0
15	IP 4	4	0		0		0
16	28	28	0		0		0	0	0	0
17	OP 0	0	0		0		0
18	0	0	0		0		0	0	0	0
19	*****************	***************	****************	*******	******	*******	*********	*********************	***************	*************
MH10

How Can I convert into a table for Access?

Example:

MH10.TXT
	A	B	C	D	E	F	G	H	I	J	K
20	CDM	Decription	Type	Total Current Ferquency	Total Current Volume	Total YTD Frequency	Total YTD Volume	Other Current Ferquency	Other Current Volume	Other YTD Frequency	Other YTD Volume
21	611-0007	CVP Cath 14 or 17	IP	1	7	4	28	1	7	4	28
22	611-0007	CVP Cath 14 or 17	OP	0	0	0	0	0	0	0	0
MH10

 

[venkat1926]

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