Export to Excel

navuser1navuser1 Member Posts: 1,329
Dear Sir,

How to export data into a single column of a CSV File.
Data length may exceed 250 Characters.

Is it possible without using any dataport/xmlport within NAV 2009 R2 System ?

Thanks in advance.
Now or Never

Comments

  • navuser1navuser1 Member Posts: 1,329
    Excel Automation is useful in this case :D
    Now or Never
  • navuser1navuser1 Member Posts: 1,329
    Through Excel Automation I'm able to create the CSV file but when I'm trying to open the file it gives the error message like

    "The file you are trying to open,'filename.csv', is in a different format....."


    So, what is the correct method to create a CSV file within NAVISION ?
    Now or Never
  • tinoruijstinoruijs Member Posts: 1,226
    Maybe you could create your own mibuso-accounts so posts like this make more sense?

    Maybe this post can help you for creating a csv; http://mibuso.com/forum/viewtopic.php?f=14&t=43458

    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • navuser1navuser1 Member Posts: 1,329
    File open issue is solved.

    The following may helps others.
    xlBook.SaveAs(filename.csv,6);
    Now or Never
Sign In or Register to comment.