|
I think it's a very common case to import data from an excel file to sql server 2005 thru a stored procedure. There are many solutions solutions such as OpenDataSource methods, cmd call DTS packages etc.
However i have not succeeded in find a receivable solution when the excel file is on the local machine. These methods work only if the file is at the same volume where the sql server is. But what happens if the excel file is at the local volume? I've read all the previous topic - export to excel - and have searched to a lot of other communities but the result was nothing. Has anyone came up against a similar situation?
Thanks in advance
www.netsemantics.gr
|
|
|
|
|
If you want to import an excel file using tools or utilities provided by SQL Server, then the SQL Server must have access to the file. It doesn't matter where the file is. It can be on a network share etc as long as SQL Server can read it.
If your excel file is located on your local machine and you're not able to provide access to it from the db server, you can use utilities like bcp on your client machine to get the data to the SQL Server.
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
Hi All,
Its been 2 weeks i am facing this issue.
I have sql server 2005 with Reporting services on Windows server 2003 64 bit machine.
I have configured the dashboard and its working . Sometime it is showing the generated report
But 9 out of 10 times i am getting error.When i checked the log files
at C:\Program Files (x86)\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles below error is displaying
11/27/08 10:31:22, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3096
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x20154C3C
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
11/27/08 10:31:29, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
11/27/08 10:31:29, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0153.mdmp
11/27/08 10:31:29, ACTION, w3wp.exe, Watson Invoke: No
Again in event view for Application application below error is coming
Event Type: Error
Event Source: Windows Search Service
Event Category: Gatherer
Event ID: 3083
Date: 11/27/2008
Time: 10:32:13 AM
User: N/A
Computer: CIGSCMMETRIC01
Description:
The protocol handler Search.Mapi2Handler.1 cannot be loaded. Error description: Class not registered.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Please can anyone help me
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
|
Hi Jerry,
Url is not working
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
It should work now.
The world is a stage and most of us are desperately unrehearsed.
—Sean O’Casey, Playwright
|
|
|
|
|
Thanks Jerry ,
Searching for fix now ...
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
hi
i want to implement data versioning in a CMS.
before it I want to realize it's methods and approches.
if u present PDFs or articles it is the best.
who can help me?
bye
Mohammad Khansari
|
|
|
|
|
Is there no search button at the top of your screen? Does google not work where you live?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
hi
ha ha ha ha
what did u mean?
google is working here!!!!!!!!
bye.
Mohammad Khansari
|
|
|
|
|
m-khansari wrote: what did u mean?
I mean its as easy for you to use the seach function on CP or google as it is for anyone else to do the search and send you the links. Its generally known as doing your own research, unfortunately it does not seem to be widely practiced judging by the majority of posts on these forums.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
hi prodigy
i have searched by google these words
versioning software
versioning system
versioning .net
versioning control
versioning database
versioning tools
versioning C#
versioning ADO.net
content versioning
versioning implementation
versioning methods
row versioning
record versioning
data versioning
but i reached only 2 articles in this field
one article in code project and another in some thing else
can u tell me what expression i must search to reach more articles?
thanks
Mohammad Khansari
|
|
|
|
|
You said
m-khansari wrote: i want to implement data versioning in a CMS.
before it I want to realize it's methods and approches
So first decide on what you actually mean. Do you want to know about data versioning in general, or in relation to a specific CMS product. If the latter, then check with the vendor. If it the former, what do you actually want to know, what it means or how to do it.
As I say, nobody can really help as you are not clear in your requirements.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
hi
thanks very much.
I want to know how to improve and enhance data versioning performance
and I want to know it's approachs in general.
God bless
Mohammad Khansari
|
|
|
|
|
I think you are trying to run before you can walk.
m-khansari wrote: I want to know how to improve and enhance data versioning performance
OK, so you need a good understanding of deltas etc associated with versioning
m-khansari wrote: I want to know it's approachs in general
Seems you don't much understanding about how it really works.
I suggest you google for methods of version control and learn from there.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Ca any I tell me the maximum number of input or output parameter a sql stored procedure can have?
|
|
|
|
|
In Books Online, the sql server help, search for "maximum capacity" - it will tell you the answer and loads more useful/interesting (boring?) bits of information.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Thanks Bob. This is really great.
|
|
|
|
|
2,100
The world is a stage and most of us are desperately unrehearsed.
—Sean O’Casey, Playwright
|
|
|
|
|
|
Just a simple addin that does things locally. Not a full and sophisticated web solution or an addin that requires access to a webserver,etc..
I need to be able to add sort of Todo markers in my source code, and be able to easily get to the source code line. Just simple things, in order to manage things myself. not something for team work.
Thank you in advance.
|
|
|
|
|
Wrong site, try rentacoder.com.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
How to unlock a table in sql server 2005? I tried killing the transaction which has a lock on the table by finding the spid through the sp “sp_lock” but still I’m not able to unlock the table.
A simple select query on this table with no “where” clause takes lot of time, resulting in Timeout Expired error. The table structure is also pretty simple with only one clustered index and the table has got only one record.
Please let me know what I can do in this scenario.
Thanks
meeram395
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
Or you could use WITH(NOLOCK) if you just want to query the table.
|
|
|
|
|
The transaction has to rollback, so that takes as long (or even longer) than the transaction had been running when you killed it. Everything should go back to normal eventually, if not then you may have to restart the sql server instance.
Bob
Ashfield Consultants Ltd
|
|
|
|
|