Convert INI files

[New Comer]

hello all,

How can import a folder of *.INI files into a excel sheet or Access Table? see contents of a sample file.
[AddressLibrary]
DataName=Messrs Berry & Berry
DataAddress1=fdfdsfdf
DataAddress2=dfdgfg
DataAddress3=hffggg
DataAddress4=dfdfd
DataDX=fdfdf
DataFax=qqqqqqqqqqq
DataEMail=ddddd
DataPhone=fffdfdf

Thanks for your help.

Zam

 

[Norie]

What exactly do you want to do?

Can't you just goto File>Open... select All Files from the Files of type drop down, locate the ini file(s) and then follow the text import wizard?

 

[New Comer]

sorry I did not explain properly. What I want to do is to create a macro to read the Section keys and values line by line then import those valuesa and put in a table of fields.

 

[Norie]

Zam

Did you try my suggestion at all?

If you need a macro you could record one when doing what I suggested?

Also could you explain the format you want the data in?

 

[Andrew Poulsom]

Have a look here.