Convert ".all" file to Excel, Or import it to use in Access?

speedygonzalez
speedygonzalez used Ask the Experts™
on
Hi, I have received a file with extension type ".all" I think this may have come from some IBM system.
I need to use this file in either Excel or an Access DB. If I save it as a txt file and import it into either application it does not keep the headers correctly, or I can't seem to use it ok.

Does anyone know how such a file can be processed & if it can be used somehow in Access or Excel?

Thank you!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
upload a copy of an ".all" file
Top Expert 2016
Commented:
if you can save the file with a ".txt" extension, you can import it to Access table correctly using a file Import Specification.
I think .ALL files might have come from Lotus 123 (an old spreadsheet program).  Therefore you might be able to get some free conversion software?
Also, have you tried renaming it to .CSV and double clicking?
Top Expert 2016
Commented:
if you can save the file with a ".txt" or ".csv" extension, you can import it to Access table correctly using a file Import Specification.

Author

Commented:
Hi All, thanks for the help.  I note in Access there is an option to import a file from lotus 123. The file extension options available are .wk and .wj but there is not option for ".all".

I cannot upload a copy of my ".all" file as it contains important data I would not like to compromise. I note to separate each value there is an ~  character, Therefore this seems to be the equivalent of a "," or a quote " which would be used in CSV. Has any of you come across this delimeter being used within a file before? Importing it as a .rxt or .csv file does not separate the values correctly. At the start of each line there is no "~" attribute either. I will try a search & replace on the "~" to replace it with a comma "," but I guess this may not work either.

Any further suggestions welcome!
Top Expert 2016
Commented:
what version of office are you using?

as i've mentioned above, you can use a file Import Specification to do this, i need to know the office version you are using.
Have you tried copying to .wk first and then using the import from 123 option?

I've not seen the ~ used as a delimiter before.

If you are sure of the structure, it would be fairly easy to knock up a script to reformat it into CSV.
When importing, you can select the delimiter charater.  A tilde can be entered ~.
When opening the file with notepad, do you see any program names that could be declaring the file type?  Or, if you just get data and/or field names, the text file wizard should work for you.
The only known use of .ALL is for Cubase song files.   I have seen users rename many different types of files with extensions.  Users that were unaware that the extension helped to identify the file type.

Author

Commented:
Hi All, Thank you for your help.

I was able to import the file to Excel by specifying the ~ delimineter in the import settings while importing it as a txt file.

Thanks all for the help. I'll give capricorn1 the points as while he did mention using Access for the import I could do this also via Excel.

Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial