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.
| Author |
Topic |
|
satish.gorijala
Posting Yak Master
182 Posts |
 Posted - 2009-03-31 : 02:58:12
|
| Hi, i know the method to import data from excel file to sqlserver.But right now, i have a file with .xlsx extension. When i select Microsoft excel 97-2003, its not accepting. I can;t save .xlsx file to xls.Because, the .xls file contains 878890 records. but .xls file only take 65000 records. so, how can i import this data to sqlserver through dTS pakages. I tried with by saving .xlsx file to csv. And i select Flat file source in DTS screen. But i am getting junk characters...G. Satish |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-03-31 : 06:14:19
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926&whichpage=17#445330MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
How to import .xlsx file data to sqlserver