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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-01-13 : 09:15:22
|
| Hi,I have a file called name.csv1-When I open this file, it does not look formatted nicely...2-I also have the name.xls file. When I open it, it gives a message: "The file you are trying to open, 'file.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?If I click on No then nothing is opened. If click on Yes, then a nicely formatted excel file is opened.using the import wizard in sql server I am unable to import any of these two files into a sql server table.I basically would like to get a dump of the data in the file into a table.The only way to do this successfully is to change the extension of the file to .txt and then the flatfileconnection can recognize the formats and then I can move it to a destination table in sql server. The wizard uses the default settings i.e delimited, etc...Question:How can I get the .xls or .csv to import?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-13 : 09:51:47
|
| how did you generate this xls/csv? seems like its format is not proper.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
import file using ssis wizard