Hello there, Well, you need to do something else with the imported data. Let's say that you have imported vendor information, e.g. addresses. Then this job would do the trick: static void FixAddress(Args _args) { VendTable vendTable; ttsbegin; while select forupdate vendTable { vendTable.AddressMap::FormatAddress(); vendTable.doUpdate(); } ttscommit; } Hope this helps. /Jens
_____ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Faiqa Khushi Sent: Monday, January 22, 2007 7:37 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Import Addresses in AX Importance: High How do we import data into the Lookups from Excel sheet? I am facing an issue while importing addresses in AX. I have define Address Format in Basic module and assigned this format to my country. It imports the data successfully but don't show address according to defined attached format. But when I select the country using lookup it format my address properly . Please reply me urgently if anyone else had faced this issue and can guide me to resolve it. Regards, Faiqa [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]