I am trying to import and excel spreadhseet into the database by right clicking the database, tasks, import. I chosen excel as the source and went through the wizard.
It goes through all the tasks
Initilizing data flow,success
Setting SQL command,success
Setting source connection,success
Setting destination connection,success
prepare for execute,success
copy to dbo.SofUseComp (It hangs here)
It hangs on the copy part of the import wizard, any ideas where I can look to see whats going on. I have imported small files without any problem.
This spreadsheet has ten columns and 1,048.576 rows
thanks everyone in advance