I attach a database_diagram and hope it will answer your question.

There were some blank positions after "19tum LCD skärm" and when I deleted these even this row appeared in the table.

Gunilla

more problems ...

I have six tables, each has a primary key and foreignkeys.

One table is (lonekat) with a primary key lonekat_id and the column manadslon filled with data and a...

Thank you, now I understand better why it doesn´t work.

Gunilla

The destination table is created by this code:

USE kursdatabas

GO

CREATE TABLE kurs.utbetalning

(utbetalning_id INT IDENTITY(1,1),

personal_id INT NULL,

grundlonNUMERIC(10,2)NOT NULL,

bonus ...

I have tried lots of scripts for example:

Select personal_id

INTO kurs.utbetalning

FROM kurs.personal

GO

INSERT INTO kurs.utbetalning

SELECT personal_id FROM kurs.personal

GO

INSERT INTO kurs.utbetalning (personal_id)

SELECT personal_id FROM kurs.personal

GO

They all give error messages.

Thank you.

Select personal_id

INTO kurs.utbetalning

FROM kurs.personal

GO

gives error: Msg 2714, Level 16, State 6, Line 2

There is already an object named 'utbetalning' in the database.

The name of the table...

Thank you so much. I deleted the column in the databasetable which hads no information for the moment in the inported file. And then it did work! I think I...

Jeff Moden (5/24/2010)

---

varkstad (5/24/2010)

---

For now I solved this unicode problem when I changed

42" Plasma TV to 42tum Plasma TV

but I still don´t get the swedish characters å,ä,ö, correct in the...

For now I solved this unicode problem when I changed

42" Plasma TV to 42tum Plasma TV

but I still don´t get the swedish characters å,ä,ö, correct in the databasetable.

Gunilla

Here come some more information for the databasetable:

CREATE TABLE kurs.kund

(kund_idINT IDENTITY(1,1),

kundansvarig_idINT NOT NULL,

fornamnCHAR(20) NOT NULL,

efternamn ...

Hi again,

I have database file with a customer table containing the following columns:

customer_id(PK,int,not mnull)

customerresponsible_id (FK,int, not null)

firstname (char(29)), not null)

secondname (char(29)), not null)

telephonenr (char(15), not null)

mobiletelephonnr (char(15), not null)

I try...

Thank you for the answer.

lmu92 (5/24/2010)

---

You should add the following two options to import unicode data:

CODEPAGE = 'RAW'

DATAFILETYPE = 'widechar'

That should help you to import your Swedish...