looks like a character field has all numeric digits. use excel text () function to format the field. it should work.
let me know if it doesn't Riyaz --- In Axapta-Knowledge-Village@yahoogroups.com, Tushar Joshi <[EMAIL PROTECTED]> wrote: > > Cristina, > > How to import from a *.csv file? i saved my excel into a .csv type of file but when trying to import it through import option it does not allow me to select the file of tyep .csv!! > > -Tushar > > Cristina Carcelén <[EMAIL PROTECTED]> wrote: > Try to import from an *.csv file. Maybe you have some blanks records. > > > --------------------------------- > De: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta- [EMAIL PROTECTED] En nombre de Tushar Joshi <[EMAIL PROTECTED]> > Enviado el: viernes, 21 de marzo de 2008 20:18 > Para: Axapta-Knowledge-Village@yahoogroups.com > Asunto: Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax > > > > Hi Nitesh, > > Thanks a lot for reply! but i tried this already... i have a doubt... if i try to import a single record then it is success but when i try to import another one it syas record already exists.... is it something to do with Number Sequences??? would appriciate if u cud throw some light on this :) > > Tushar > > Nitesh <[EMAIL PROTECTED]> wrote: > Hi Tushar, > > seems Record already exist in Table > > From Import Dialog box go to Import Rule Tabpage and select the > Option clear table before Import from Import Rule field. > > Regards > Nitesh > > On 3/21/08, Tushar Joshi <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I am trying to import the masterdata provided by client into Ax 4.0 SP2. > > > > I created a new blank company account in Ax to import data n started the > > excelimport through Administration -> Periodic -> Data Import/export -> > > excel spreadsheets -> excel import. but it gives an error and says "the > > record already exists and import is interrupted." can anyone help me on how > > to import data through excel? > > > > The excel sheets were given ti client were created from same company > > account with a defnition group created. > > > > plz help.. > > > > Regards, > > Tushar > > > > > > --------------------------------- > > Meet people who discuss and share your passions. Join them now. > > > > > --------------------------------- > 5, 50, 500, 5000 - Store N number of mails in your inbox. Click here. > > #ygrp-mkp { BORDER-RIGHT: #d8d8d8 1px solid; PADDING-RIGHT: 14px; BORDER-TOP: #d8d8d8 1px solid; PADDING-LEFT: 14px; PADDING- BOTTOM: 0px; MARGIN: 14px 0px; BORDER-LEFT: #d8d8d8 1px solid; PADDING-TOP: 0px; BORDER-BOTTOM: #d8d8d8 1px solid; FONT-FAMILY: Arial } #ygrp-mkp HR { BORDER-RIGHT: #d8d8d8 1px solid; BORDER- TOP: #d8d8d8 1px solid; BORDER-LEFT: #d8d8d8 1px solid; BORDER- BOTTOM: #d8d8d8 1px solid } #ygrp-mkp #hd { FONT-WEIGHT: bold; FONT-SIZE: 85%; MARGIN: 10px 0px; COLOR: #628c2a; LINE-HEIGHT: 122% } #ygrp-mkp #ads { MARGIN-BOTTOM: 10px } #ygrp-mkp .ad { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING- TOP: 0px } #ygrp-mkp .ad A { COLOR: #0000ff; TEXT-DECORATION: none } #ygrp-sponsor #ygrp-lc { FONT-FAMILY: Arial } #ygrp- sponsor #ygrp-lc #hd { FONT-WEIGHT: bold; FONT-SIZE: 78%; MARGIN: 10px 0px; LINE-HEIGHT: 122% } #ygrp-sponsor #ygrp-lc .ad { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; MARGIN-BOTTOM: > 10px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-mlmsg { FONT: x-small arial,helvetica,clean,sans-serif } #ygrp-mlmsg TABLE { FONT-WEIGHT: normal; FONT-SIZE: 100%; LINE-HEIGHT: normal; FONT-STYLE: normal; FONT-VARIANT: normal } #ygrp-mlmsg SELECT { FONT: 99% arial,helvetica,clean,sans-serif } INPUT { FONT: 99% arial,helvetica,clean,sans-serif } TEXTAREA { FONT: 99% arial,helvetica,clean,sans-serif } #ygrp-mlmsg PRE { FONT: 100% monospace } CODE { FONT: 100% monospace } #ygrp-mlmsg * { LINE-HEIGHT: 1.22em } #ygrp-text { FONT-FAMILY: Georgia } #ygrp- text P { MARGIN: 0px 0px 1em } #ygrp-tpmsgs { CLEAR: both; FONT- FAMILY: Arial } #ygrp-vitnav { FONT-SIZE: 77%; MARGIN: 0px; PADDING-TOP: 10px; FONT-FAMILY: Verdana } #ygrp-vitnav A { PADDING-RIGHT: 1px; PADDING-LEFT: 1px; PADDING-BOTTOM: 0px; PADDING- TOP: 0px } #ygrp-actbar { CLEAR: both; MARGIN: 25px 0px; COLOR: #666; WHITE-SPACE: nowrap; TEXT-ALIGN: right } > #ygrp-actbar .left { FLOAT: left; WHITE-SPACE: nowrap } bld { FONT-WEIGHT: bold } #ygrp-grft { PADDING-RIGHT: 0px; PADDING- LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 15px; PADDING-TOP: 15px; FONT-FAMILY: Verdana } #ygrp-ft { PADDING-RIGHT: 0px; BORDER-TOP: #666 1px solid; PADDING-LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 5px; PADDING-TOP: 5px; FONT-FAMILY: verdana } #ygrp-mlmsg #logo { PADDING-BOTTOM: 10px } #ygrp-reco { PADDING-RIGHT: 0px; PADDING- LEFT: 0px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-reco #reco-head { FONT-WEIGHT: bold; COLOR: #ff7900 } #reco-grpname { MARGIN-TOP: 10px; FONT-WEIGHT: bold } #reco-category { FONT-SIZE: 77% } #reco-desc { FONT-SIZE: 77% } #ygrp-vital { PADDING-RIGHT: 0px; PADDING-LEFT: 8px; MARGIN- BOTTOM: 20px; PADDING-BOTTOM: 8px; PADDING-TOP: 2px; BACKGROUND- COLOR: #e0ecee } #ygrp-vital #vithd { FONT-WEIGHT: bold; FONT- SIZE: 77%; TEXT-TRANSFORM: uppercase; COLOR: #333; > FONT-FAMILY: Verdana } #ygrp-vital UL { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 2px 0px; PADDING-TOP: 0px } #ygrp-vital UL LI { CLEAR: both; BORDER-RIGHT: #e0ecee 1px solid; BORDER-TOP: #e0ecee 1px solid; BORDER-LEFT: #e0ecee 1px solid; BORDER-BOTTOM: #e0ecee 1px solid; LIST-STYLE-TYPE: none } #ygrp- vital UL LI .ct { PADDING-RIGHT: 0.5em; FONT-WEIGHT: bold; FLOAT: right; WIDTH: 2em; COLOR: #ff7900; TEXT-ALIGN: right } #ygrp-vital UL LI .cat { FONT-WEIGHT: bold } #ygrp-vital A { TEXT- DECORATION: none } #ygrp-vital A:hover { TEXT-DECORATION: underline } #ygrp-sponsor #hd { FONT-SIZE: 77%; COLOR: #999 } #ygrp-sponsor #ov { PADDING-RIGHT: 13px; PADDING-LEFT: 13px; MARGIN- BOTTOM: 20px; PADDING-BOTTOM: 6px; PADDING-TOP: 6px; BACKGROUND- COLOR: #e0ecee } #ygrp-sponsor #ov UL { PADDING-RIGHT: 0px; PADDING-LEFT: 8px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px } #ygrp-sponsor #ov LI { PADDING-RIGHT: 0px; > PADDING-LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 6px; PADDING- TOP: 6px; LIST-STYLE-TYPE: square } #ygrp-sponsor #ov LI A { FONT- SIZE: 130%; TEXT-DECORATION: none } #ygrp-sponsor #nc { PADDING- RIGHT: 8px; PADDING-LEFT: 8px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; BACKGROUND-COLOR: #eee } #ygrp-sponsor .ad { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 8px; PADDING-TOP: 8px } #ygrp-sponsor .ad #hd1 { FONT-WEIGHT: bold; FONT-SIZE: 100%; COLOR: #628c2a; LINE-HEIGHT: 122%; FONT-FAMILY: Arial } #ygrp-sponsor .ad A { TEXT-DECORATION: none } #ygrp- sponsor .ad A:hover { TEXT-DECORATION: underline } #ygrp- sponsor .ad P { MARGIN: 0px } o { FONT-SIZE: 0px } MsoNormal { MARGIN: 0px } #ygrp-text TT { FONT-SIZE: 120% } BLOCKQUOTE { MARGIN: 0px 0px 0px 4px } replbq { MARGIN: 4px } > > > --------------------------------- > Bring your gang together - do your thing. Start your group. >