Problem with import data from excel format file.

[Hon Seng Phuah]

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

[Lyndon Hills]

On 2 Dec 2003 02:21:24 -0800, hs*****@usa.com (Hon Seng Phuah) wrote:

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

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.

[Simon Hayes]

hs*****@usa.com (Hon Seng Phuah) wrote in message news:<38*************************@posting.google.c om>...

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

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