SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 can not import data as excel or text file
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lydia
Starting Member

Cambodia
34 Posts

Posted - 10/21/2013 :  11:14:51  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3559 Posts

Posted - 10/21/2013 :  11:28:42  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 10/21/2013 :  14:40:22  Show Profile  Reply with Quote
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

Cambodia
34 Posts

Posted - 10/22/2013 :  02:55:46  Show Profile  Reply with Quote
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

Cambodia
34 Posts

Posted - 10/22/2013 :  03:21:27  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 10/22/2013 :  07:55:53  Show Profile  Reply with Quote
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

Cambodia
34 Posts

Posted - 10/23/2013 :  05:13:55  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 10/23/2013 :  08:45:07  Show Profile  Reply with Quote
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

Cambodia
34 Posts

Posted - 10/28/2013 :  00:25:56  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 10/28/2013 :  07:06:18  Show Profile  Reply with Quote
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

Cambodia
34 Posts

Posted - 10/29/2013 :  04:59:37  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 10/29/2013 :  05:13:11  Show Profile  Reply with Quote
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

Cambodia
34 Posts

Posted - 10/29/2013 :  05:25:26  Show Profile  Reply with Quote
hi visak,

could you please tell me how to check?

thanks
Go to Top of Page

lydia
Starting Member

Cambodia
34 Posts

Posted - 10/29/2013 :  05:33:17  Show Profile  Reply with Quote
Hi visak,

Any GUI in sql server 2008 that i can change?

Thanks
Go to Top of Page

lydia
Starting Member

Cambodia
34 Posts

Posted - 10/30/2013 :  22:49:45  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 10/31/2013 :  00:30:00  Show Profile  Reply with Quote
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

Cambodia
34 Posts

Posted - 11/01/2013 :  22:32:43  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 11/02/2013 :  13:32:11  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000