Open Large amount of data

[Former Member]

Hi

I have a file on application server in .dat format, it contains large amount of data may be 2 million of records or more, I need to open the file to check the record count, is there any software or any option to open the file, I have tried opening with Notepad, excel .... it gives error..

please let me know

Thanks

[Former Member]

Hi,

Try this..

Go to AL11..

Go to the file directory..Then in the file there will be field called length..which is the total length of the file in characters..

If you know the length of a single line..

Divide the length of the file by the length of single line..I believe you will get the number of records..

Thanks,

Naren

[Former Member]

Hi Narendran

I think length of single line may not be equal everytime, because in some lines there may not be some values.

please correct me if I am wrong

Thanks

[venkata_ramisetti]

Hi KP,

I don't think what I am saying is not a good approch. But if don't find any other solution, you can try the following.

Use OPEN DATASET, READ DATASET & CLOSE DATASET and move the data to an internal table and check number of entries using DESCRIBE statemenmt.

Thanks

Ramakrishna

[Former Member]

Try importing into Access.

[Former Member]

Hi,

Try Importing into Access?

Could you please explain, how to do it.

Thanks

[Former Member]

1. Open MS Access

2. Click "New"

3. Click "Blank database"

4. Give it a name and click "Create"

5. Go to File->Get External Data->Import...

6. Change file type to your file extension

7. Select your file and click "Import"

8. Select "Delimited" radiobutton and click "Next"

9. Select "Other" radiobutton and enter your delimiter in the box

10. Click "Finish"

[Former Member]

Great Michael,

It worked !!

Thanks

[Former Member]

Glad it worked for you. Access is a nice alternative to Excel when you have large datasets or if quick querying in a SQL environment is necessary.

[Former Member]

Hi,

Is your file tab delimited file..

Thanks,

Naren

[Former Member]

NO,

pipe de-limited file

Thanks