From excel to SQL Server 2000

Last Post 24 Feb 2013 06:24 AM by gunneyk. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
river1
New Member
New Member

--
19 Feb 2013 02:39 PM
Hi,

I have one excel that has data like this:

ADM14021360066,208930705 502151 Abraçadeiras Plasticas Wurth 280x4,8 UN 1000.1 NOVO 200 Camião
ADM14021360066,208930706 502161 Abraçadeiras Plasticas Wurth 360x4,8 UN 1000.1 NOVO 300 Camião
ADM14021360066,208930707 2 Barra Reparação Magnum UN 1000.1 NOVO 2 Camião
ADM14021360066,208930708 3 Bicos Cola UN 1000.1 NOVO 70 Camião
ADM14021360066,208930709 4 Bidon Limpeza Travões Wurth 20Lt UN 1000.1 NOVO 1 Camião
ADM14021360066,208930710 7 Clip Autocolante UN 1000.1 NOVO 64 Camião
ADM14021360066,208930711 147334 Cola Fernador Azul Berner UN 1000.1 NOVO 1 Camião
ADM14021360066,208930712 147321 Cola Fernador Verde Berner UN 1000.1 NOVO 1 Camião
ADM14021360066,208930713 89309 Cola Klebfix Wurth UN 1000.1 NOVO 2 Camião
ADM14021360066,208930714 81 Cola Loctite Preta UN 1000.1 NOVO 1 Camião
ADM14021360066,208930715 0893449f Cola Metal Liquido Wurth1 UN 1000.1 NOVO 1 Camião
ADM14021360066,208930716 4242 Cola Past-o-Fix Berner UN 1000.1 NOVO 0 Camião
ADM14021360066,208930717 8963092f Cola Plastofix Wurth UN 1000.1 NOVO 2 Camião

There are several values that are imported as null on column codigo.


For instance, the code that is on excel as 8963092f is imported to the column codigo as null.

Can someone explain why?


thanks,

Pedro


P.S table code:


CREATE TABLE [dbo].[table2] (
[STSTAMP] [char] (25) COLLATE Latin1_General_CI_AS NULL ,
[CODIGO] [varchar] (1000) COLLATE Latin1_General_CI_AS NULL ,
[DESIGNACAO] [varchar] (1000) COLLATE Latin1_General_CI_AS NULL ,
[UNIDADE] [varchar] (1000) COLLATE Latin1_General_CI_AS NULL ,
[FAMILIA] [varchar] (1000) COLLATE Latin1_General_CI_AS NULL ,
[ESTADO] [varchar] (1000) COLLATE Latin1_General_CI_AS NULL ,
[QUANTIDADE] [varchar] (1000) COLLATE Latin1_General_CI_AS NULL ,
[LOCALIZACAO] [varchar] (1000) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]
GO


rm
New Member
New Member

--
20 Feb 2013 06:09 AM
Likely data type mismatch between excel and sql table.
gunneyk
New Member
New Member

--
24 Feb 2013 06:24 AM
What is the delimiter? You don't have a consistant delimiter between the fileds in the data file.
You are not authorized to post a reply.

Acceptable Use Policy