To import data of an Excel sheet from SQL Server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

To import data of an Excel sheet from SQL Server

Hi!<br />I have a problem when I try to import data of an Excel sheet from SQL Server Enterprise Manager. I follow all the steps rightly, even I reach to see the right data of Excel, and finally when the import process begin the same error appears every time: ‘The operative system does not admit the sequence of selected arrangement(ordination)'<br /><br />Help me please! [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Cesar
Can you speciy the steps defined above.
It looks like a new error and how about SQL & SP level using. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Please: What SQL (version, SP) and Excel are you using? Luis Martin
I use the standard assistant to import data from sql Server Enterprise Manager. The sql version is ‘Microsoft SQL Server 2000 Personal’, and the Excel version is ‘Microsoft Excel 2000 (9.0.2812)’. My operative system is windows ’98. Cesar
So you’re using DTS import/export wizard for the process.
Try to define a new package with a new excel sheet. BTW what is the data format on excel you’re trying to export? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

This Win 98 sounds fishy to me… Does this have to do something with distributed transactions? Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

What about the MDAC? What is the version that you are using? Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Save the excel file as a comma seperated text file instead and try to import it. If it still fails you might have some merged columns or something in the excel sheet. /Argyle
How about apply w/ newest patch? With my experience, it’s the best resolution to resolve unexpected errors. Ted Kim
Sr. System Engineer
CJ Systems
Agree with Argyle.
Should be something in your Excel sheet.
I use this very frequently and never experienced problems with the Import Wizard. In almost all cases it was some mistake in the underlying Excel data. So, maybe this is of some value for you!
I think the DTS wizard bases his estimations on a sample of the first few (8 or 10, if I remember right) columns.
You should verify that there is no blank line following later on which you are trying to import. In addition verify that all column are of equal type. Cheers,
Frank
GOOD !
I have read with attention all your comments, and already I have solved the problem. The problem was the Excel sheet data format, I had three columns and every one needed their own format, and the format was ‘general’ for all columns instead. Thank you friends!!
Cesar
]]>