Problem with import data from excel format file.

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Hon Seng Phuah
    #1

    Problem with import data from excel format file.

    Hi all,

    I have a huge excel format file wants to export to sql server
    database. One of the field has combination of numeric and
    alphanumeric. When I import the excel format to sql server database,
    the numeric is successfully imported but the alphanumeric does not
    import at all.

    Does anyone know how to solve my problem?

    Thanks.

    -HS Phuah
    Tags: None
    • Lyndon Hills
      #2
      Re: Problem with import data from excel format file.

      On 2 Dec 2003 02:21:24 -0800, hsphuah@usa.com (Hon Seng Phuah) wrote:
      [color=blue]
      >Hi all,
      >
      >I have a huge excel format file wants to export to sql server
      >database. One of the field has combination of numeric and
      >alphanumeric . When I import the excel format to sql server database,
      >the numeric is successfully imported but the alphanumeric does not
      >import at all.
      >
      >Does anyone know how to solve my problem?
      >
      >Thanks.
      >
      >-HS Phuah[/color]
      Is the data in that column in the first row to be processed completely
      numeric? Maybe if you sorted it such that this was alpha, sql server
      would recognize the column as being alphanumeric and bring the lot in.

      I'm assuming that you haven't defined the table in your db, and are
      letting some tool do it for you.

        Comment

        • Simon Hayes
          #3
          Re: Problem with import data from excel format file.

          hsphuah@usa.com (Hon Seng Phuah) wrote in message news:<3898598f. 0312020221.e23a 72c@posting.goo gle.com>...[color=blue]
          > Hi all,
          >
          > I have a huge excel format file wants to export to sql server
          > database. One of the field has combination of numeric and
          > alphanumeric. When I import the excel format to sql server database,
          > the numeric is successfully imported but the alphanumeric does not
          > import at all.
          >
          > Does anyone know how to solve my problem?
          >
          > Thanks.
          >
          > -HS Phuah[/color]

          You really need to give some more information - what version of SQL
          Server, how are you importing the file, what format are the source
          data in, what is the DDL for the target table, what does "not import"
          mean?

          One possibility is that the data type of the target column doesn't
          allow alpanumeric characters. Another is that you're seeing this
          issue:

          http://www.sqldts.com/default.aspx?254


          Simon

            Comment

            Previous template Next
            Working...