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 |
|
ashuadi
Starting Member
5 Posts |
 Posted - 2007-06-11 : 10:17:47
|
| I am having some trouble importing the file from excel 2007 into sql server 9.0. The excel file is being stored as .xslx and sql server is not accepting this extension. When I save the file as .xls, sql server allows me to import the file but with only 256 columns (my file has around 500 columns). Any anyone please give me some suggestions as to how to fix this. Thanks! |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-06-11 : 12:05:57
|
| save it as a csv and see what happens.-ec |
 |
|
|
|
|
|
problem in file import