Hi,

I am trying to import data from excel sheet into my SQL server.
Actually i was trying out different ways of copying data from MySQL to
SQL Server. I exported data from MySQL to a excel and then tried
importing data from the excel sheet to SQL Server. But the import/
export wizard fails with a error message 'External table is not in the
expected format' (In the datasource field of the import/export wizard
i selected 'Microsoft Excel'). I then open the file in excel did save
as 'Microsoft excel workbook' and then i try to import data it works
fine. But the thing is in between these tasks i was doing i get 'The
program SqlWb.exe stopped interacting with Windows and was closed.'
error in the event log. My SQL server just hangs. I got this error
twice while trying to import data. Can anybody help me with this? BTW
i would like to know what is SqlWb.exe?

Thanks
Bharath

"SqlWb.exe" is the file name of SQL Server Management Studio.

Weird that SSMS crashes, because Import\Export Wizard's application is
different (DTSWizard.exe). Does DTSWizard crash also or it can be terminated
properly?

--
Ekrem Önsoy


"bharath_r" <bharath.0523 (AT) gmail (DOT) com>, iletisinde sunu yazdi,
news:88e9e784-7775-495d-972f-9d31664245a3 (AT) r34g2000vba (DOT) googlegroups.com...

On May 28, 9:42*pm, Ekrem Önsoy <ileti... (AT) ekremREMOVE-THISonsoy (DOT) net>
wrote:
When the SqlWb.exe crashed, the DTSWizard was not open. I'm sorry, i
din't put forward my question properly. When i said in between these
tasks i got the SqlWb.exe error, i din't mean i kept the DTSWizard
open. I tried importing the data from Excel and when i got the
'External table is not in the expected format' error, i saved it as
Excel Workbook and tried again. This time it worked so i went back to
MySQL exported the data again to Excel and again tried importing. This
time the DTSWizard din't come up. My SQL Server just hung. After i
posted i tried replicating the same thing, but i could not.
Also can you tell me why i am getting 'External table is not in the
expected format' error?

Regards
Bharath

can you tell me why i am getting 'External table is not in the
expected format' error?

I really can not guess what's going on there. However I can suggest you to
export your data into *.CSV format and then import from that CSV file. This
could be a better way to import your data.

--
Ekrem Önsoy



"bharath_r" <bharath.0523 (AT) gmail (DOT) com>, iletisinde sunu yazdi,
news:30f77b5f-4fd6-4d95-83f8-bc4b2d2cdcde (AT) v4g2000vba (DOT) googlegroups.com...
On May 28, 9:42 pm, Ekrem Önsoy <ileti... (AT) ekremREMOVE-THISonsoy (DOT) net>
wrote:
When the SqlWb.exe crashed, the DTSWizard was not open. I'm sorry, i
din't put forward my question properly. When i said in between these
tasks i got the SqlWb.exe error, i din't mean i kept the DTSWizard
open. I tried importing the data from Excel and when i got the
'External table is not in the expected format' error, i saved it as
Excel Workbook and tried again. This time it worked so i went back to
MySQL exported the data again to Excel and again tried importing. This
time the DTSWizard din't come up. My SQL Server just hung. After i
posted i tried replicating the same thing, but i could not.
Also can you tell me why i am getting 'External table is not in the
expected format' error?

Regards
Bharath