Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 can not import data as excel or text file

Author  Topic 

lydia
Starting Member

34 Posts

Posted - 2013-10-21 : 11:14:51
Dear Team,

I have problem with sql server 2008. I can not import data as excel file or text file.Could you please tell me ,how can i solve this issue.
Thanks in advance.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-10-21 : 11:28:42
What kind of problems/error messages are you getting when you try to import?

There are a number of ways to import Excel file into SQL - see here for details and examples: http://support.microsoft.com/kb/321686

For text files, you can use similar methods, but in addition you can also use BCP and BULK INSERT. Examples here: http://technet.microsoft.com/en-us/library/aa337544.aspx
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-21 : 14:40:22
what do you mean by import data as excel file or text file

do you mean transfer data from excel/text files to sql tables or do you mean storing files themselves?


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

lydia
Starting Member

34 Posts

Posted - 2013-10-22 : 02:55:46
Hi James K,
The error message is as following:

This wizard will close because it encountered the following error:
Additional information:
General access denied error

Thanks.
Go to Top of Page

lydia
Starting Member

34 Posts

Posted - 2013-10-22 : 03:21:27
Hi Visakh 16,

I mean transfer data from excel/text files to sql tables.

Thanks

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-22 : 07:55:53
quote:
Originally posted by lydia

Hi James K,
The error message is as following:

This wizard will close because it encountered the following error:
Additional information:
General access denied error

Thanks.


thats a very generic error message.
Can you show the query/steps you used to set this up?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

lydia
Starting Member

34 Posts

Posted - 2013-10-23 : 05:13:55
Hi Visak,

my step is
Right-click on the name of the database
Import Data from the Tasks menu
Click Next
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-23 : 08:45:07
ok so its export import wizard
do you've access to path where youwere trying to create excel files?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

lydia
Starting Member

34 Posts

Posted - 2013-10-28 : 00:25:56
Hi Visak,

I can not access to the path where i keep excel,
i can only right click and then next. Message alert error

Thanks :)
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-28 : 07:06:18
quote:
Originally posted by lydia

Hi Visak,

I can not access to the path where i keep excel,
i can only right click and then next. Message alert error

Thanks :)


then how will you be able to save excel file in that path?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

lydia
Starting Member

34 Posts

Posted - 2013-10-29 : 04:59:37
hi Visak,

let me explain you again, i have problem with import by wizard,
i right click on the name of database-->Tasks-->import data-->next--> i got message alert(This wizard will close because in encountered the follow error), I don't know what this error mean, and how could i solve this problem? where should i change?

Thanks
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-29 : 05:13:11
Check if you've access to do export/import data in the db.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

lydia
Starting Member

34 Posts

Posted - 2013-10-29 : 05:25:26
hi visak,

could you please tell me how to check?

thanks
Go to Top of Page

lydia
Starting Member

34 Posts

Posted - 2013-10-29 : 05:33:17
Hi visak,

Any GUI in sql server 2008 that i can change?

Thanks
Go to Top of Page

lydia
Starting Member

34 Posts

Posted - 2013-10-30 : 22:49:45
hi visak,

yes,Any GUI in sql server 2008 that i can change?

Thanks
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-31 : 00:30:00
See what roles your login is mapped in SQL server for the database. Expand Security -> login. double click on login and see securables tab against your database.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

lydia
Starting Member

34 Posts

Posted - 2013-11-01 : 22:32:43
Hi visak,

I have checked my user is super account(sa).
I will uninstall and install again.
Because i can not found the problem.

Thanks so much for your kind support me.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-11-02 : 13:32:11
why not create a proxy account for executing wizard and give it access to your path where file goes.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -