[lthemi02]

i want to import the data from a txt file and import them in the sql server 2008 tables, is there any way to do that without using the buld insert method? This is the error i get from buld insert method that i use
Msg 4834, Level 16, State 4, Line 7
You do not have permission to use the bulk load statement.

[modi123_1]

Why not just add your login to the bulkadmin server role?

[lthemi02]

we dont have access there.

[modi123_1]

... this is for your work, right, or what environment are you dealing with?

Worse comes to worse you can write a small vb.NET app to read in data from your source and run an insert statement against the table.

[lthemi02]

i am a student and i have a partial access to the database server and my permissions are mostly restricted

[modi123_1]

... okay then it begs the question are you supposed to be inserting data into this database?

[lthemi02]

yes i should because this is the exercise i have to do. i have to import the data from an excel file and i cant find anything that works

[modi123_1]

Do you have to use the SQL Management Studios or can you connect to it with a VB.NET app?

[lthemi02]

i can only work with SQL SERVER MANAGEMENT 2008 and JAVA

[modi123_1]

Okay.. then write a small app in java that reads the data in and runs the TSQL INSERT statement for all the data..