ADO 2.1/VBScript/Access97 
Author Message
 ADO 2.1/VBScript/Access97

I'm hoping somebody in this newsgroup will be able to help me. I'm a
relative newbie to ADO, but I have spent several days reading ADO specific
newsgroups, and reading the MSDN ADO documentation but I am still confused .

There are several tasks that I am attempting to accomplish.

1. I am wanting to use VBScript with ADO to read a fixed-length text file
containing 2 text (character)fields  using the  Access97 TEXT provider?

2. After reading each record from the text file I will do some record
manipulation with this text  record and then write this modified record to
an Access97  .mdb database.

3. I understand at this point I need to use ADOX to create an empty .mdb
database.  I have a code sample for this, but I do not know how to create a
table, or to create the fields  with specific field types. The table will
only have 3 fields, 2 of which are text(character) fields that have been
read from the text file above, with the 3rd field being generated by
vbscript (depending on the value of one of the text file fields). This 3rd
field will be a hyperlink field type.

So I guess I'm asking for either code snippets or boilerplate code that
would allow me to accomplish the above 3rd step.

I have seen numerous examples of ASP server-side code, but can find no
examples for Client-side VbScript local machine processing. I also have had
a very difficult time finding any VBScript coding examples. What confuses me
is that in the few vbscript code examples I have seen, they all seem to be
using different techniques to basically do the same thing.

If anybody can provide me with any examples, idea,websites,etc which will
help me accomplish the above I will be very appreciative. TIA

If there are any regular readers of this newsgroup who are interested in
ADO/VBScript/Access97 programming who might like to get together via chat or
email , that would be great too.



Fri, 08 Feb 2002 03:00:00 GMT  
 ADO 2.1/VBScript/Access97
Shock,

One suggestion that I have for you is to s{*filter*}using the TEXT driver for #1.
Try using the FileSystemObject, ReadLine and various text functions to parse
the file and fields.  You'll be much better off and it's quite fast to do
that.

For #2, there are various ways to do that.  Use the ADO methods or just
issue dynamically built SQL strings.  that's up to you.

#3.  If you are intent on learning ADOX (not a bad thing to be intent on),
then you *need* the DASDK 2.1 update.  Run, don't walk, to
www.microsoft.com/data and get the 2.1 update.  There is another CHM help
file in the update that contains good documentation on ADOX.   I've just
started looking at it myself to perhaps automate the installation of a data
syncing application that I've written.  There are pretty good samples in
this help file.

Good Luck,
John Alderson
Systems Analyst
Goodwin, Procter & Hoar LLP

Quote:

>I'm hoping somebody in this newsgroup will be able to help me. I'm a
>relative newbie to ADO, but I have spent several days reading ADO specific
>newsgroups, and reading the MSDN ADO documentation but I am still confused
.

>There are several tasks that I am attempting to accomplish.

>1. I am wanting to use VBScript with ADO to read a fixed-length text file
>containing 2 text (character)fields  using the  Access97 TEXT provider?

>2. After reading each record from the text file I will do some record
>manipulation with this text  record and then write this modified record to
>an Access97  .mdb database.

>3. I understand at this point I need to use ADOX to create an empty .mdb
>database.  I have a code sample for this, but I do not know how to create a
>table, or to create the fields  with specific field types. The table will
>only have 3 fields, 2 of which are text(character) fields that have been
>read from the text file above, with the 3rd field being generated by
>vbscript (depending on the value of one of the text file fields). This 3rd
>field will be a hyperlink field type.

>So I guess I'm asking for either code snippets or boilerplate code that
>would allow me to accomplish the above 3rd step.

>I have seen numerous examples of ASP server-side code, but can find no
>examples for Client-side VbScript local machine processing. I also have had
>a very difficult time finding any VBScript coding examples. What confuses
me
>is that in the few vbscript code examples I have seen, they all seem to be
>using different techniques to basically do the same thing.

>If anybody can provide me with any examples, idea,websites,etc which will
>help me accomplish the above I will be very appreciative. TIA

>If there are any regular readers of this newsgroup who are interested in
>ADO/VBScript/Access97 programming who might like to get together via chat
or
>email , that would be great too.



Sat, 09 Feb 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. ADO 2.1/VBScript/Access97

2. Wallet 2.1 causes 8002802b VBScript error when clicking the PayNow button

3. DHTML, Access97, ADO and VB Scripting

4. Almost there?? : WSH/ADO/Access97

5. EPSF fix to some Transcript 2.1 utilities

6. %%BoundingBox hacks for Transscript 2.1 psdit.c

7. trouble installing TranScript 2.1

8. WTB: Used or distress Acrobat Capture 2.1

9. SetPageDevice Question - Level 2 or 2.1?

10. MDAC 2.1 and Access 97(-) Incompatable

11. GS 510...using ps2pdf for Acrobat 2.1....

12. ANNOUNCE: PDFprint 2.1: to print PDF files

 

 
Powered by phpBB® Forum Software