Word Documents
Feb 22, 2006
Yesterday I installed MS SQL 2000 for the first time and have no idea what I'm doing.
I have been sent a database and asked to convert this to MS Access, for most of the data that is ok and I have already managed to do this. My problem is that the database contains MS Word documents stored in some of the tables (field type - image). I need to extract these from the database and get them back to individual Word files, ideally with a file name that relates them to the primary key of the table from which they came.
I have less that 24 hours experience with SQL server and would be very grateful if anyone can explain how I can do this.
Thank you for your help
Shane
View 2 Replies
ADVERTISEMENT
Jun 1, 2001
Is it possible to bring the entire contentsof a Word document into text filed, in order to be able to use full-text indexing?
View 3 Replies
View Related
Oct 22, 1999
I need a help with respect to the storage of documents in SQL server. Is it possible to store Word documents in SQL Server straight away ? If yes, what is the data type that is supported for this kind of storage.
How do I read the data , store it & render it ( using both ado & Just TSQL)
Thanks,
Meera
View 1 Replies
View Related
Dec 2, 1999
Is it possible to have a word document as a datatype? I am attempting to create a searchable SQL 7 database of approximately 5000 resumes, adding anywhere from 10-100 every day (we are a recruiting/consulting firm).
I know index server is an easier way to do this, but my managers are against it for unknown reasons.
Other ideas are also welcome...
Thanks in advance,
Kevin
View 1 Replies
View Related
Jan 30, 2007
Hi All,
I need to import multiple word documents of same structure into SQL Server table. Could anyone suggest the way of doing this?
Thanks,
View 4 Replies
View Related
Oct 17, 2004
Hi,
I have developed a Job Registration page, in which, the resume attached will be stored in the database in an image data-type field. Now, the client program includes migration of the database into local server and process the resumes.
After migration to the local database, if the client wants to process the resume and save directly to the database again, is it possible? This a very urgent requirement. Currently, i am separating the resume from the database and storing in a folder with the ID as the file name. But i want to convert it to a distributed application, which needs the resume to be in the database itself.
Can anybody suggest me the method to open .doc file from the database, process it and save directly to the database?
Thanks and regards,
mrc
View 2 Replies
View Related
Jul 20, 2005
Hi folks,I want to be able to store and retrieve UNSAVED Word documents as BLOBs. Igot all the info for storing them if they're already saved on the filesystem. But what if they're not already saved? I could save them to a tempfile first and then make it a blob, but I'd rather not put them on the filesystem at all. I could use Document.Contents to get the Range object for thewhole doc and then BLOB that, but I'm not sure that would be quite the sameas a .doc file, maybe things like Styles and the like would be missing.TIA!Dave
View 2 Replies
View Related
Mar 19, 2006
can we use full text search and mining algorithms to comapre two word or text documents to find out if they are similar
please help.
thaks for reading
View 3 Replies
View Related
Dec 11, 2006
How can I search throught DOCX (MS Word 2007) documents by SQL Server 2005 Full Text Search engine?
Should I something download?
View 6 Replies
View Related
Jan 26, 2007
Excel 2007 Documents Not Displayed in Windows XP Professional sp2
Start Menu's Recent Documents List:
Dear Microsoft Support:
I can't figure out how to get recently used Excel 2007 (new file formats) documents to show up in the Windows XP Professional (sp2) Start Menu's Recent Documents List. I checked the Internet, the knowledgebase, many parts of the MS web site, etc. for an answer but can't find one.
Are Excel 2007 documents supposed to show up in the XP Start Menu's Recent Document List? Is this a bug or do I have to do some sort of configuration to make it do so? If it's a bug, when will a fix be available?
Are these new Excel 2007 files filtered out like EXE files are which will not appear in the Recent Document List?
The Excel 2007 file types are listed in the Registry.
This question is also posted on Experts-Exchange...No solutions yet.
Thanks.
Jim.
View 1 Replies
View Related
Feb 24, 2008
i have report with parameter and he can have a null in parameter ther is null word can i change it to another word like all or any thing else
View 4 Replies
View Related
Mar 30, 2005
hi!
I'm just wondering does anyone know how to create an sql command that can search word by word?
what i mean is like I have a product with name 'harry potter broom'.
I want an sql command where if i type only 'harry broom' this 'harry potter broom' product will show up.
Does anyone have any idea?
Here's my sql comand: (I'm using asp.net vb script do develop this system)
-------------------------------------------------------------------------
query = "select distinct * from product where " & _
"(pname like '%" & keyword & "%' or " & _
"pdesc like '%" & keyword & "%' ) and " & _
"(price >= " & price1 & " and price <= " & price2 & _
") and status <> 'out of stock' order by price asc"
-------------------------------------------------------------------------
Thank you.
View 4 Replies
View Related
Sep 24, 2007
Is the word "Name" a reserved word in SQL? look at line 10 of my stored procedure. When I use the word "Name"it is highlited in blue by SQL Server?
Note I only list part of the stored proc
1 CREATE PROCEDURE [dbo].[GetXMLPeopleNames] 23 (4 @Status nvarchar(3)5)6 AS7 SELECT8 PersonId,9 PersonDescription,10 Name,11 UpdateDate,12 UpdateAppUser13 FROM14 Customer WHERE Customer.PersonDescription=@Status15 ORDER BY
View 2 Replies
View Related
Jan 31, 2007
Hello,I need to create a database to hold documents information.1. Basically, I need the following information for each document: Title, Description, LastUpdated, Category, Type, Url Should I create tables for Category and Type? And link them to my documents table? What type of relationship should I use?2. I also need to know how many downloads each document had Should I add a column in my documents table? Then I would increase it one by one. Or should I create a new table which would register each download.3. I need to let users to rate each document from 1 to 5. How should I implement this?Thank You Very Much,Miguel
View 3 Replies
View Related
Jul 20, 2000
I'd like to create an XML document from within SQL 7.0. Is the do-able? I know it's build into SQL 2K. But how is it done (or can it be done) in SQL 7.0.
Thanks,
Kurt
View 3 Replies
View Related
Jul 31, 2007
Hello All,
I have been experimenting with SQL Server 2005 partitions. I loaded a terabyte of information into 2 tables. The first holds the document information and the second holds the actual binary document (in this case pdf). Most of the documents are about 1 megabyte in size, but the largest is 212 megabytes.
SQL Server has no problem storing the blobs. The problem occurs when I attempt to get the data.
I did some quick tests to test how fast I could pull the documents out. The largest took about 24 seconds. The 1 meg documents are sub-second.
Here is how the 212 meg doc breaks down:
Time to load datatable: 18.79 seconds
Time to load byte array: 3.84 seconds
Time to Write and open document: 0.01 seconds
If I access the file from a file server, the time is 0.04 seconds to begin showing the document.
As you can see, the longest time period is related to retrieving the data from SQL, and it is much slower that launching it from disk across the network. (note: the sql server and file server used to test are next to each other).
My question is, how can I speed up the access from SQL Server? I believe the keys are "partition aligned". Any suggestions would be appreciated.
I will add the table definitions and partition information as a reply since only 5000 chars are allowed in the post.
View 12 Replies
View Related
Dec 14, 2006
This may be a stupid question but I'll throw it out here, is it possible to use sql 2005 to split up pdf files into individual files by a field on the form or an index?
Thanks.
View 1 Replies
View Related
Mar 28, 2008
We have a document library that we display on report manager. When we open a pdf document there is a print icon, but when we open an Excel document or a Word document, there is no ablility to print. The user must save the document locally and then reopen it to print from Word or Excel. Is there a setting somewhere that can be set to enable printing on the Excel and Word docs?
View 3 Replies
View Related
Apr 11, 2007
Hi,
I have the requirements to add the attachment, so i am saving the documents in sqlserver.
now i am facing the problem with openning the document.
can any body suggest me how to open the documents which are stored in sql server
View 4 Replies
View Related
Aug 22, 2007
Hi,
I was wondering if I can save documents e.g. pdf, word, excel or anyother format in sql2005.
If yes what datatype should I use and what would be the best way to go about it.
Thanks in advance
View 4 Replies
View Related
May 27, 2008
Hi all,
I need to migrate some documents(in GB's) from FTP Server1 with meta data information in SQLdbA to FTP Server2 with meta data information in SQLdbB. How can we achieve this?
Am new to this concept and got information that we can use FTP task. But unable to proceed how to achieve this. Please help me.
View 2 Replies
View Related
Jun 8, 2006
I am developing a resume storage system, and don't know the best way to store the resumes that come in to our company in both MS Word and text files. Should I store the files in the original format they come in, and reference the file name in the databse that points to a directory where they are stored, or should I store the text of the resumes directy in the database. There are 2 things that I must follow.
1: I need to have the documents keep their formatting.
2: I also need the capibility of conducting a full text search to pull out key words from the documents.
What is the best way?
View 1 Replies
View Related
Jan 16, 2007
Hello,
Brief overview. Got 2 tables, client table and document table. Both tables have client name as the primary key. Client table shows client info, address, phone, dob. Document table shows client name, document, document type.
I need to write a query that will count how many documents are in the table for each name.
This is attempt at it, please let me know whats wrong. Thanks.
SELECT count [client table].client name as cli_name, count ([document table].name as doc_qty)
FROM [client table] INNER JOIN [document table] ON [client table].id = [document table].ID
GROUP BY [client table].name
ORDER BY [client table].name
View 6 Replies
View Related
Dec 9, 2011
I am still finding my feet with sql server.I want to allow users to upload different versions of documents. However I want them to be able to access the previous versions if they need to. Below, is some info (there are other fields, but not necessary here) from a table 'file_resources':
file_idfile_nameversion original_file_id
406 ppt1 4 403
405 ppt3 3 403
404 ppt1 2 403
403 ppt1 1 403
402 excel1 1 402
The problem I have is that I want to display the latest version details by default but have a link to previous versions of the document.
So, when I run the following sql:
SELECT file_id, version
FROM file_resources
ORDER BY file_id DESC, version DESC
it returns:
file_idversion
406 4
405 3
404 2
403 1
402 1
But what I need to get is the 2 unique documents (The latest file_id where original_file_id is duplicated):
406
402
View 1 Replies
View Related
Aug 6, 2015
I need to build a query that can return only documents where the field "u_DIM4" for the same document have more than one different value..my script are this one just to having an example:
Select docnome [documentname], adoc [docnr], count(*) [countAlldifferentbyDoc], u_dim4
from fn
where u_dim4 <> '' and data between '2015-01-01' and '2015-07-31'
AND adoc = '02634'
Group by docnome,adoc,u_dim4
ORDER BY 2 asc
[code]...
View 4 Replies
View Related
Jul 20, 2005
I am creating a document management systems using asp. I have beenresearching the different ways of handling the documents such as using thefile system and storing the path in the db, and actually storing thedocument in the db. I like the idea of storing it in the database muchbetter because I can allow users to manage documents themselves (I alreadyhave the code in place to do it if I decide), having a central system withthe ability to add my own document properties by adding fields to the table,security, and backups. I have found that most think it is better to storethe path due to performance issues and the rate the db can grow. I havelooked at our current system in access and we have a total of 4400 documents(of which probably 25% are in the database but don't actually exist anymorein the file system, one hangup about the file system) since 1988. Thiscomes to about 300 documents added each year. The other thing is the issuewith the size of the db. I don't see a whole lot of difference with thisissue because it is going to take up space in your file system too, althoughthe file system may be more efficient at storing them. I would say that 95%of our docs are under 1 mb in size and done in ms word.The last thing is using full-text search capabilities in SQL Server. I needto be able to search the contents of the field.Is there other issues around storing documents in the db to consider besidesthe above?
View 1 Replies
View Related
Feb 1, 2008
Hi,
I was wondering if someone was able to comment on something that I've encountered using SSRS.
I have set some items with the ToggleItem property and viewing the report, the [+] and [-] buttons show. However when the report is exported (to pdf, mhtml or even tif), the icons are no longer there.
Is there a way to get these to appear?
Thanks in advance.
Alex
View 1 Replies
View Related
Jul 31, 2007
Does anybody know how to store objects like files in a database column/
I am familiar with MSAccess (use BLOB) and Oracle (use varchar200?
Raymond
View 1 Replies
View Related
Jan 2, 2008
I am trying to attached database which is My Documents using SQL Express, but when it goes to C:Documents and SettingsRAFAL I can not see any folders below.... I can see folders in Explorer!
Is this some kind of bug? I am using SQl Express 2005. I have shared C:Documents and SettingsRAFAL folder with everyone.
Also another problem is that when attaching database it does not rememeber the last path I was attaching from...
View 1 Replies
View Related
Mar 14, 2005
Is there any tool that documents all the users and their privilage levels in a given database??
I looked at SQL Scribe tool but it doesn't care about documenting users at all!
We need this for documenting hundreds of databases for SOX purpose.
Thanks,
View 8 Replies
View Related
Jun 26, 2014
I have been asked to look into using Filestream for centralising MS Office documents (mostly excel).I am worried about the "user interface" aspect.I read that there are "this and that" APIs to read/write data to the filestream but surely one would need to write a specific interface to Word/Excel... which feels like far too hard.I am a great admirer of SQL Server but is it the right tool for document management?
We use SQL Server 2012 and have offices round the world with various internet connection quality.Our main aim is to stop the current "spreadsheet nightmare" so common with Excel.
View 9 Replies
View Related
Jun 22, 2007
I need someone that knows something about SQL queries.
I have a client that is running a Database known as ProLaw. It is in part a
document management system for Law Offices.
They have an SQL 2005 database that tracks per client all the documents they
create.
We had to replace there server with new server. The new server is running
sbs2003 and had to have a different Netbios name then the old sbs2000
server. (Small Bus. Server has some weird quirks that make simply using the
same netbios name impossible. Google search it if you don't believe me.)
The database holds in a single column the full network share path to each
document.
A document for example may have had a path of
"\lawwillsbs2000ProlawDocumentsACME wigets Incsmith_deposition.doc"
Different documents may have different names and more subdirectories but the
root path of "\lawwillsbs2000ProlawDocuments" is shared by all.
The new server is named \sbs2003 I need to change
the first part of almost 3000 path statements to the new server. The rest
of the path is unchanged.
I have had several people running prolaw tell me that I should run this
query:
UPDATE Events
SET DocDir=REPLACE(DocDir, '\\lawwillsbs2000', '\\sbs2003')
WHERE EventKind='O'
This doesn't work. Nothing is changed. I'm guessing it is because this
query assumes the value will be ONLY \lawwillsbs2000 I see nothing in here that tells the query that this is only part of the string. No wild card or other marker.
I need some kind of string function here do I not? Anyone know enough to
help me craft a proper query?
Thanks
Nathan Williams
View 3 Replies
View Related
Jul 20, 2005
Hi There,Being quite new to MS-SQL I would like to ask if there is a general opinionof what approach should be taken to storing things like external documentsand images in databases.Should the actual files be stored within the database, or instead shouldlinks to the files on a file server or something similar be stored instead.For the end user I imagine it is easier to have everything stored within thedatabase, because doing it the other way in effect gives another level ofmanagement because there is the need to perhaps manually look after the fileserver with all the image files or document files on.In my particular case, I am building a database where the users use a greatmany Word documents. For example, I particular record might have a number ofdifferent Word documents associated with it.I was going to create a "Documents" table that all documents were stored in(including meta data about each document because it will be really useful tobe able to search for documents so that they can be reused).In this table I was in a dilemma as to whether to actually store thedocuments in the table. Other then the performance hit and memoryrequirements this will require, are there any other disadvantages?What are the general thoughts when a database needs to manage a lot of pdfand word documents?Thanks in advance.Dave.
View 3 Replies
View Related
