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,
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
SQL-Server-Performance.com All in Love is Fair
All postings are provided â€œAS ISâ€ with no warranties for accuracy.