1. TechSpot is dedicated to computer enthusiasts and power users. Ask a question and give support. Join the community here.
    TechSpot is dedicated to computer enthusiasts and power users.
    Ask a question and give support.
    Join the community here, it only takes a minute.
    Dismiss Notice

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...