Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Exporting Data into Excel (.csv) format
sudoku
Member Posts: 50
Hi
As per the requirement,I need to export Item No. and Unit Price data from Item table to Excel(.CSV) file. The data is manipulated in the excel file and is imported back into the Item Table.
Ex: Item No. 0001
Unit Price 100.00
Once the export is done , the Item No. in the excel sheet is shown as "1" instead of "0001". As I am trying to GET the Item No. ,I cannot import it back as the format of the Item No. (from 0001 to 1)has been changed .
Can anybody suggest me how to export the data in the same format from Navision to Excel(0001 as 0001).
Thx in advance
As per the requirement,I need to export Item No. and Unit Price data from Item table to Excel(.CSV) file. The data is manipulated in the excel file and is imported back into the Item Table.
Ex: Item No. 0001
Unit Price 100.00
Once the export is done , the Item No. in the excel sheet is shown as "1" instead of "0001". As I am trying to GET the Item No. ,I cannot import it back as the format of the Item No. (from 0001 to 1)has been changed .
Can anybody suggest me how to export the data in the same format from Navision to Excel(0001 as 0001).
Thx in advance
0
Comments
Excel will interpret it as a text instead of a numeric.
edit - Oops just read that you are using csv not automation. Sorry this doesn't work for csv files. Not sure what you can do...
char := 160. It's empty space and excel will show the whole list, but you'll have that character in the column.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n