Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: Access data type conversion

    Have an issues with converting a data type.

    Currently i have two columns that have entries such as 73.125 in every cell. There are 79,900 entries. Currently the column is a text data type and I need to convert it to a number format. However, whenever I try to do this the decimal points get cut off. It is crucial that I keep the decimal points. Is there anyway to do this within access, or through a processing page in ASP?

    - Conrad

  2. #2
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    32
    Try this:

    1) Export your table into a TXT file.
    2) Re-import your TXT file and use the following parameters:
    delimited width
    text qualifier: "
    data type: double

    It takes long to convert 79,900 entries but it works.

    peter

Posting Permissions

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