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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 loading xlsx file in sql server 2005

Author  Topic 

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-04-02 : 00:33:56
Hi all,

I have a xlsx file to load into 2005 seq sever, its not working.

I loaded the file into access 2008 then tried loading access db table into 2005 even that didnt work.

how to load this file, kinldy help.
as one tab has 4lakh records which is > 65000, else I could have converted it to xls file and loaded.

Regards,
aak

aakcse
Aged Yak Warrior

570 Posts

Posted - 2009-04-02 : 00:41:04
Trying to exp the access 2008 file to csv and load in sqlserver 2005.

lets c if this works..

quote:
Originally posted by aakcse

Hi all,

I have a xlsx file to load into 2005 seq sever, its not working.

I loaded the file into access 2008 then tried loading access db table into 2005 even that didnt work.

how to load this file, kinldy help.
as one tab has 4lakh records which is > 65000, else I could have converted it to xls file and loaded.

Regards,
aak

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-02 : 04:06:20
Also try using connection string for xlsx
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -