Hi ,
I have the following report in Note pad, this an example of only one record.
How Can I convert into a table for Access?
Example:
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 |