9 Replies - 942 Views - Last Post: 26 November 2012 - 02:58 PM Rate Topic: -----

#1 lthemi02  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 26-November 12

sql server

Posted 26 November 2012 - 02:12 PM

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.
Is This A Good Question/Topic? 0
  • +

Replies To: sql server

#2 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9573
  • View blog
  • Posts: 36,253
  • Joined: 12-June 08

Re: sql server

Posted 26 November 2012 - 02:18 PM

Why not just add your login to the bulkadmin server role?
Was This Post Helpful? 0
  • +
  • -

#3 lthemi02  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 26-November 12

Re: sql server

Posted 26 November 2012 - 02:22 PM

we dont have access there.
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9573
  • View blog
  • Posts: 36,253
  • Joined: 12-June 08

Re: sql server

Posted 26 November 2012 - 02:29 PM

... 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.
Was This Post Helpful? 0
  • +
  • -

#5 lthemi02  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 26-November 12

Re: sql server

Posted 26 November 2012 - 02:34 PM

i am a student and i have a partial access to the database server and my permissions are mostly restricted
Was This Post Helpful? 0
  • +
  • -

#6 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9573
  • View blog
  • Posts: 36,253
  • Joined: 12-June 08

Re: sql server

Posted 26 November 2012 - 02:37 PM

... okay then it begs the question are you supposed to be inserting data into this database?
Was This Post Helpful? 0
  • +
  • -

#7 lthemi02  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 26-November 12

Re: sql server

Posted 26 November 2012 - 02:51 PM

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
Was This Post Helpful? 0
  • +
  • -

#8 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9573
  • View blog
  • Posts: 36,253
  • Joined: 12-June 08

Re: sql server

Posted 26 November 2012 - 02:52 PM

Do you have to use the SQL Management Studios or can you connect to it with a VB.NET app?
Was This Post Helpful? 0
  • +
  • -

#9 lthemi02  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 26-November 12

Re: sql server

Posted 26 November 2012 - 02:58 PM

i can only work with SQL SERVER MANAGEMENT 2008 and JAVA
Was This Post Helpful? 0
  • +
  • -

#10 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9573
  • View blog
  • Posts: 36,253
  • Joined: 12-June 08

Re: sql server

Posted 26 November 2012 - 02:58 PM

Okay.. then write a small app in java that reads the data in and runs the TSQL INSERT statement for all the data..
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1