+ Reply to Thread
Results 1 to 3 of 3

Started out as an Access problem. Now an Excel problem

  1. #1
    RobertM
    Guest

    Started out as an Access problem. Now an Excel problem

    Hello:

    The problem that I'm having is that when I import data into an Access table
    from Excel some of the values are converted to scientific format. Below is
    the text from an Access discussion board on this. I've tried converting the
    data to text, but it still goes scientific on me. I'm dealing with 1000's of
    rows of data here so my going in and placing a comma before each record isn't
    feasible unless someone can tell me a shortcut way to do this.

    Any help is appreciated!

    Thank you



    You need to format the cells (in Excel) as text and make sure that Excel
    does not automatically change the format to scientific when the data is
    entered (as Excel does, and you can't turn this feature off!!!)

    If you have problems with this, it may be better to post in an Excel group.

    MH


    "RobertM" <RobertM@discussions.microsoft.com> wrote in message
    news:6B67A862-81C0-4930-A2C5-3410E46431B1@microsoft.com...
    > Hello:
    >
    > Here's what;s happening:
    >
    > 1. I'm using a macro to import data from Excel to an Access Table
    >
    > 2. The info being imported is a 9 digit text identifier. Sometimes it has
    > leading zeros, sometimes it has letters mixed in. In the Access table the
    > feild is text. When the info comes over into the Access table some of the
    > values appear as shown below:
    >
    > 6.29E+110
    >
    > This is not good. I need to assure that on the import it dosen't change to
    > a
    > scientific value.
    >
    > Thank you.




  2. #2
    Dominic
    Guest

    RE: Started out as an Access problem. Now an Excel problem

    Hi Robert,

    If placing a comma before the cell data would do it, how about using a
    helper column with the formula : = "," & A1

    Where your data is in column A

    Copy that formula down for all of your rows.

    Would that work?




    "RobertM" wrote:

    > Hello:
    >
    > The problem that I'm having is that when I import data into an Access table
    > from Excel some of the values are converted to scientific format. Below is
    > the text from an Access discussion board on this. I've tried converting the
    > data to text, but it still goes scientific on me. I'm dealing with 1000's of
    > rows of data here so my going in and placing a comma before each record isn't
    > feasible unless someone can tell me a shortcut way to do this.
    >
    > Any help is appreciated!
    >
    > Thank you
    >
    >
    >
    > You need to format the cells (in Excel) as text and make sure that Excel
    > does not automatically change the format to scientific when the data is
    > entered (as Excel does, and you can't turn this feature off!!!)
    >
    > If you have problems with this, it may be better to post in an Excel group.
    >
    > MH
    >
    >
    > "RobertM" <RobertM@discussions.microsoft.com> wrote in message
    > news:6B67A862-81C0-4930-A2C5-3410E46431B1@microsoft.com...
    > > Hello:
    > >
    > > Here's what;s happening:
    > >
    > > 1. I'm using a macro to import data from Excel to an Access Table
    > >
    > > 2. The info being imported is a 9 digit text identifier. Sometimes it has
    > > leading zeros, sometimes it has letters mixed in. In the Access table the
    > > feild is text. When the info comes over into the Access table some of the
    > > values appear as shown below:
    > >
    > > 6.29E+110
    > >
    > > This is not good. I need to assure that on the import it dosen't change to
    > > a
    > > scientific value.
    > >
    > > Thank you.

    >
    >


  3. #3
    Dave O
    Guest

    Re: Started out as an Access problem. Now an Excel problem

    After you import to Excel and find scientific notation, re-format those
    cells to present the information in your desired number format.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1