Export to Excel

navuser1
navuser1 Member Posts: 1,334
edited 2014-12-09 in NAV/Navision Classic Client
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

  • navuser1
    navuser1 Member Posts: 1,334
    Excel Automation is useful in this case :D
    Now or Never
  • navuser1
    navuser1 Member Posts: 1,334
    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
  • tinoruijs
    tinoruijs 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
  • navuser1
    navuser1 Member Posts: 1,334
    File open issue is solved.

    The following may helps others.
    xlBook.SaveAs(filename.csv,6);
    Now or Never

Categories