Home > IT Answers > Business Intelligence > I need to up load an excel file to sql server db with vb
Xs40
10 pts.
 I need to up load an excel file to sql server db with vb
Crystal Reports, Importing Excel to SQL, Microsoft Excel, SQL Server stored procedures, Visual Basic
I need to upload a excell file to sql server. I made a Stored procedure with the openrowset but if i run de stored procedure works, but embebed in visual basic or in crystal repor an error appears.Somethig about serverliked or server trusted i don't rememeber. does somebody an idea? thanks in advance

Software/Hardware used:
ASKED: January 19, 2009  6:52 PM
UPDATED: January 22, 2009  1:10 PM
RELATED QUESTIONS
Answer Wiki:
It could be any number of things. Without the exact error message there isn't a whole of information anyone will be able to procide.
Last Wiki Answer Submitted:  January 21, 2009  4:51 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

The error message is an important piece of information here.
I would run the program again, to see the message.

carlosdl
 63,535 pts.
 

Have you tried uploading the file using the DTS packages/jobs. Also, let us know the error message and connection type you are using to perform this task

Sarfaraz Ahmed
Free Microsoft Excel help

Findsarfaraz
 1,395 pts.