SQL error when importing

[Orphanmaker1]

I'm using SQL 2000 on my server, but editing the db's using Access..

When I try importing my access .mdb into my SQL db, it won't import the most important tables...i.e. merchant/monster/std_items etc etc.

I get various errors as shown below:

Can anyone help? cos i'm really confused...i've tried just importing an indentical TBL_Npc with one extra npc added to it (in addition to the npc's already in the table which do work) and it just fails.

oh and also i can't seem to close my m2server after opening it... just stays running until i reboot pc :/

 

[Kaori]

have you truncate the table first?
the right side (null) thing was probably those empty fields in your table.

why don't you use enterprise manager to edit things?

if you insist on using access... you can edit data directly without EXPORTING/IMPORTING. (with ODBC)

 

[Orphanmaker1]

How do I truncate?

Those fields aren't empty they have 0 in :/

It's a long story but I only have SQL on my server machine which I use remotely, so isn't as fast and using Access on my laptop.

Also I don't have ODBC and don't know what it is, do you have a link plz?

 

[paul.obrien]

just go to your sql right click on the tbls and delete them totaly.
then when you import the new database it will copy the new set.
If you just import over the top of a current table it will simple add all the information twice.So you must delete each tabble before you import a new one

 

[Azura]

Doesnt every computer have ODBC in the adminitative tool?

 

[Orphanmaker1]

Doesnt every computer have ODBC in the adminitative tool?

Oh ye it does but I don't and can't have SQL installed on the computer that I wanna do the editting on..so ODBC can't connect to the db anyway.

I've managed to work around some of the tables thanks to what paul said, but TBL_STDITEMS is proving problematic. It's still showing that same error I posted originally, about row 651 having NULL values or data which violates contraints.

I've looked at this row (it's PoisonMarble) and the MC/SC/MAX fields are all set to 0...nothing unusual to the other marbles before it. I've even tried setting them to 1 and still says the same error, same when I delete the row entirely.

Any clues?

 

[Kaori]

you can still use odbc to that computer. as long as the port is opened and setup properly.

 

[Orphanmaker1]

Well clearly I know nothing about setting it up...lol

 

[Kaori]

Google is your friend.

http://www.google.com/search?q=connect+access+to+sql+server

 

[Orphanmaker1]

It's ok I managed to get the import working...can't remember how but it's done lol

thanks