Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chandak76
Starting Member
3 Posts |
 Posted - 2005-08-29 : 04:00:23
|
| Hi, I had a sql database management system,but unfortunatly it was over written and couldn't get my data back,What use to happen is when you index the data on the document it would print out an index sheet with a bar code which will tie up with the document.Now I've got the documents already scanned with a with a barcode number which is also the image number.Is there a way I can create a database from this information?I don't know annything about sql but I know a bit of ms access.Is there software that I can use to do this?Thanks |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2005-08-29 : 19:46:35
|
| hi chandakyou already have a database - all your documents - but its not a relational database...the real question is, what is it that you want to be able to do with it that you can't do now?If you want to take various document information and store this in a table in access, this is easy to do - take a look at the Microsoft Office 11.0 Object library - this allows you to open office documents from VBA and extract information. You could loop through your documents and extract the bar-code number, and then insert this into a table. But do you need to? You could just as easily extract the information and store the list in an excel spreadsheet. Since you admit you don't know much about SQL, this is probably a better option for you. Excel provides good basic searching and filtering for "flat-file" information, and will probably provide all the functionality you want - unless you have more than 55000 documents.--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
OCR to Access