TechSpot

import a .csv to Excel

By luvyrpet
Apr 28, 2006
  1. The database that I am using saves reports in .csv format only. One of the columns is credit card account numbers. When I open this report I first have to convert this column to text because what shows there is something like
    4.12E+ . I am able to convert this to text but what happens then it takes the very last number and changes it to a zero. So all my account numbers in the report ends with 0. The length is the same. Has anyone heard of such nonsense?
    thanks
     
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...