After copying in your data go to the vendor code and put ' in the front as
part of the code, does it show or disappear?  If it disappears try doing an
import.

Excel has some strange behaviour on so called string fields (to you it looks
like a striong field but not to excel, not until you put the ' on the
front), I kinda remember something similar with another customer but I think
in the end couldnt get the excel to except the field as string so did it via
csv (which is faster I think also).



-----Original Message-----
From: akash malohatra [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 3:49 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Excel Import


Yah , i checked the format of the cells are as
required. But still its not allowing the vendor codes.
Its entering as blank.

Regards
Akash
--- Yifat Halili <[EMAIL PROTECTED]> wrote:
> Hi there,
>
>
>
> Make sure that the format of the cells is correct.
>
> Even after you paste the data go to the cell and
> make sure that the
> excel cell is formated i.e. number, text, general
> etc.
>
>
>
> Hope this helps.
>
>
>
> Yifat
>
>
>
>
>
>
>
> ________________________________
>
> From: akash malohatra [mailto:[EMAIL PROTECTED]
>
> Sent: 05 May 2004 02:07
> To: [EMAIL PROTECTED]
> Subject: [development-axapta] Excel Import
>
>
>
> Hi All,
> Need your help.
> Axapta 3.0 SP2
>
> I created the Excel template file using the Template
> wizard for importing Vendor Master. I paste the
> required data for Vendor master from another Excel
> file to this template file.
>
> When i import , it says the record Alreday Exist. I
> checked its importing the blank values in vendor
> Account field instead of the correct vendor Account
> in
> the Excel File. Really dont know , why its happening
> like this????
>
> I saw , it happens as i copied the data from another
> Excel file and pasted in the Template excel file
> file.
> When i enter some data in the template file manually
> and trying to import , it works successfully.
>
> So, data from another Excel file, can not be pasted
> to
> the Template file.
>
> Need your comments and suggesstins.
> Regards
> Akash
>
>
>
>
>
>
>
____________________________________________________________
> Yahoo! Messenger - Communicate instantly..."Ping"
> your friends today! Download Messenger Now
> http://uk.messenger.yahoo.com/download/index.html
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
> click here
>
<http://rd.yahoo.com/SIG=129je190v/M=295196.4901138.6052515.3001176/D=gr
>
oups/S=1705006764:HM/EXP=1083802024/A=2128215/R=0/SIG=10se96mf6/*http:/c
> ompanion.yahoo.com>
>
>
>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6052515.3001176/D=group
> s/S=:HM/A=2128215/rand=479700352>
>
>
>
> ________________________________
>
> Yahoo! Groups Links
>
> *      To visit your group on the web, go to:
>       http://groups.yahoo.com/group/development-axapta/
>
> *      To unsubscribe from this group, send an email to:
>       [EMAIL PROTECTED]
>
<mailto:[EMAIL PROTECTED]
> be>
>
> *      Your use of Yahoo! Groups is subject to the Yahoo!
> Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>





____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html




Yahoo! Groups Links







Yahoo! Groups Sponsor
ADVERTISEMENT
click here


Yahoo! Groups Links

Reply via email to