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
 import xlsx files on sql 2005		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shoham
Starting Member

6 Posts
Posted - 06/04/2012 :  04:52:21  Show Profile  Reply with Quote
Hello

I'm using sql server 2005.

Is there a way to import xlsx files (exel 2007+), using the import wizard?

right now I have "Microsoft Excel" on data source field but it allows only xls extesions.

raghuveer125
Constraint Violating Yak Guru

India
277 Posts
Posted - 06/05/2012 :  04:39:27  Show Profile  Reply with Quote
I am not sure but you can do one thing. You can save your (execl 2007+) in MS Office 2000 using save as option. Then you can able to import from sql 2005

In Love... With Me!
Go to Top of Page

m.esteghamat
Starting Member

17 Posts
Posted - 06/05/2012 :  06:05:17  Show Profile  Reply with Quote
Hi
reg. solution is best and short.
but if you want read this :
1- http://www.mssqltips.com/sqlservertip/2002/import-excel-2007-data-with-sql-server-integration-services/

2- http://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm
or
3-http://www.sqlservercentral.com/Forums/Topic764585-146-1.aspx
bye
Go to Top of Page

sujaprem82
Starting Member

India
1 Posts
Posted - 06/06/2012 :  02:22:14  Show Profile  Reply with Quote
Hi,
u can save the file with.xls extension and import the file. .xlsx has encoded data for some windows servers. so its good to change the extension from .xlsx to .xls
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.05 seconds. Powered By: Snitz Forums 2000