Access to excel

[Ayesha via AccessMonster.com]

I have a table containing the following fields namely
S.No - number
Name - Text
Address - Memo

the data is stored in acess in a single cell.I want to convert acess to excel
But i want the address field to be stored in Excel in different rows as

No.12, Directors Colony,
Radhakrishnann Street,
Chennai

and not as
No.12, Directors Colony,Radhakrishnann Street,Chennai in a single cell.

Hope i am not confusing a lot.

 

[John Vinson]

I have a table containing the following fields namely
S.No - number
Name - Text
Address - Memo

the data is stored in acess in a single cell.I want to convert acess to excel
But i want the address field to be stored in Excel in different rows as

No.12, Directors Colony,
Radhakrishnann Street,
Chennai

and not as
No.12, Directors Colony,Radhakrishnann Street,Chennai in a single cell.

Hope i am not confusing a lot.

This may be a bit difficult. Basically you will need code to parse the
address and determine where to insert vbCrLf new line characters. Just
inserting after each comma won't work because you want the first comma
(No. 12,) left on the same line.

What is the logic of where you want a new line? How variable are the
addresses?

John W. Vinson[MVP]