import xlsx files on sql 2005 - SQL Server Forums

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

import xlsx files on sql 2005

Author

Topic

shoham
Starting Member

6 Posts

Posted - 2012-06-04 : 04:52:21

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

285 Posts

Posted - 2012-06-05 : 04:39:27

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!

m.esteghamat
Starting Member

47 Posts

Posted - 2012-06-05 : 06:05:17

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

sujaprem82
Starting Member

1 Post

Posted - 2012-06-06 : 02:22:14

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources