SQL Server Performance Forum – Threads Archive

Problem in Import of Excel file to a table in SQL

Dear All, I am a new kid(DBA)in the block.

I have a problem regarding Import of data from a Excel file to table in SQL Server. Though it shows that the process is succesful but no data is imported from the excel file. Thanking you with regards,
Sukrity Mondal.

Hi, 1- Do it show how many records are imported while importing excel->db?
2- Which table it is importing data in?
3- Have you used Profiler to track what is going on. ________________________________________________
~* Opinions are like a$$holes, everyone got one. *~

Try this also
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8440 Madhivanan Failing to plan is Planning to fail

Are you using DTS or what? Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>