May 23, 2008 at 7:36 am
Hi,
Can we load an Excel file in my machine from client to the server using openrowset or opendatasource.
Thanx in advance,
Balamurugan
May 23, 2008 at 9:32 am
Sure you could but I would use SSIS instead. If it is a one-time event just right-click on the database in SSMS -> select All-Tasks -> Import Data and the Wizard will walk you through it. If it is a multiple time thing you can still use the wizard just save the package and then you can schedule it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy