I need to up load an excel file to sql server db with vb

10 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    The error message is an important piece of information here. I would run the program again, to see the message.
    69,175 pointsBadges:
    report
  • Findsarfaraz
    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
    1,395 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following