Hi All,
I'm having problem with import excel file automatically into the database using SQL, i know that we can import the file manually from SQL.
However, i want it to run automatically.
That's why i am trying to write a store procedure to do that but i am having some problems.is it possible?
Thanks
-
Follow
Oops, something didn't work.
Sign In to be begin to follow this thread
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.Getting "follow" information
Start following this thread
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.Removing your "follow"
Setting up your "follow"
Did you know you can
sign up for email notifications?
-
-
I've not tried it myself, but try this...
SELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')
Get more information here...
http://support.microsoft.com/?kbid=321686
Hope that helps! -
In SQL Server 2000 you should use Data Transformation Services
In SQL Server 2005 you should use SQL Server Integration Services
DTS and SSIS packages can then be scheduled to run automatically whenever you need them.
SimonJ -
Thanks!
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.