| View previous topic :: View next topic |
| Author |
Message |
Silly Star
Newbie
Joined: 15 Jul 2005
Posts: 4
|
 Posted: Jul 16th, 2005 12:03 AM Post subject: Reading Number of .Doc files and saving in database........ |
 |
|
i m retrieving a number of .Doc files from a single folder, these files have the same data format.
i can retrieve these file with the code given below.
| Code: | Dim sFileName As String
sFileName = Dir$("C:\MyFoldername\*.DOC")
Do While sFileName <> ""
sFileName = Dir$
Loop
|
now i want to read the text form these .Doc files nd save them in the database.
i dont know how to do this.
the Data format in Files is :::::::::::::::::::
_______________________________________________________________________
Surname ___________ Forename __________ Lab No: __________ |
Age__________ Sex_______ Pat No:__________ Date _________ |
Address_____________________________________________________________ |
_______________________________________________________________________
Test | Result
HBsAg | Non-reactive (0.65)
Anti-HCV (Antibodies) | Non-reactive (0.42)
Anti-HIV I & II (Antibodies) | Non-reactive (0.30)
[/quote] |
|
| Back to top |
|
RoofRabbit
Regular
Joined: 06 Jul 2005
Posts: 95
Location: Lenoir, NC USA
|
| Posted: Jul 19th, 2005 07:39 AM Post subject: |
|
|
Are you wanting to create your own custom database or put the data into an existing database program like excel or something? I can help with making a custom database, but not very familiar with excel or lotus database programs.
_________________
Website - [link] |
|
| Back to top |
|
Silly Star
Newbie
Joined: 15 Jul 2005
Posts: 4
|
| Posted: Jul 20th, 2005 07:53 AM Post subject: |
|
|
i m using custom database created in sql server with only two tables.
one for "Person's Info" on the top of the document.
other for "Tests Record" on bottom of the document. |
|
| Back to top |
|
VB_Developer
Newbie
Joined: 25 Feb 2006
Posts: 18
Location: Hyderabad, India
|
| Posted: Feb 27th, 2006 07:34 AM Post subject: |
|
|
Hi,
Could you post your database script her, so i could take the script and create the database and give the solution as soon as possible.
Thanks
Deepak |
|
| Back to top |
|
|
