always problem for import file to server

[Dogo]

everytime i try to import file on server i got it messed up, i have try with items table, tryed with xls and csv file, both messed up my server, can anyone tell me how to do it? after 3 days Im still dont have success PLEASE help

thanks

 

[LightRitual]

I recommend you use Microsoft SQL Server 2000 instead of Window Server 2003.
Cuz, i'm success in import, export, editing anything on my server with it.
Ii haven't got any experience in using Window Server 2003 so i don't know how to solve ur problems xD
Srr for my bad eng.

 

[Twilight]

You must be registered to see links

QA Ex:

USE PS_GameDefs;
GO
BACKUP DATABASE PS_GameDefs
TO DISK = 'C:\PS_GameDefs.Bak'
   WITH FORMAT,
      MEDIANAME = 'PS_GameDefs',
      NAME = 'Full Backup of AdventureWorks';
GO

Other:
1 : SData -> ProductList.sql
2:
in QA example:
USE PS_GameDefs;
TRUNCATE TABLE [dbo].[ProductList]; --- CLEAR TABLE

3:
open and exec ProductList.sql

4:
-------------------------------------------------------
For online data edit tables:

You must be registered to see links

-------------------------------------------------------