Export to Excel

navuser1

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.

navuser1

Excel Automation is useful in this case

navuser1

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 ?

tinoruijs

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

navuser1

File open issue is solved.

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