I don't know which version of Access that Mr. Verhas has been working with, but I have used 95, 97, and 2000 a great deal over the years and I have been able to use SQL queries in all versions. My recollection of 95 is a little sketchy at this point, but I do recall that while 97 had very limited support for DDL, there wasn't anything I couldn't do with queries and 2000 supports DDL statements as well.
My suggestion is that you use Win32::OLE to control the ADO COM object. That way, if you are familiar with scripting COM objects with VB, VBA, VBScript, or JavaScript, you should find it a fairly easy task to port that to Perl. I recently had occasion to use Win32::OLE to automate MSXML and was stumped on the matter of assigning one object to be a property of a second object until Jan Dubois pointed out the LetProperty() object method to me. There are plenty of examples of scripting Excel and Word with Perl on the web to get you started. I suggest that you go over all the Win32::OLE docs to get familiar with the module, then try automating Access a step at a time. -- Charles Knell [EMAIL PROTECTED] - email (703) 234-3955 x2544 - voicemail/fax ---- "Peter Verhas" <[EMAIL PROTECTED]> wrote: > As far as I could understand when experimenting with Access the SQL > language > accepted by Access is limited. Thus you can not say > > select username,password from users > > All you can say instead is only > > select * from users > > > Similarly select count(*) may also be forbidden. > > I am not sure if your question was regarding such aproblem, but this > may > really be an issue. I faced it when I tried to debug the ODBC module > of > ScriptBasic using Access, but I have never read this in documentation. > > Regards, > Peter > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Rafferty > Uy > Sent: Friday, March 22, 2002 10:24 AM > To: ActivePerl Mailing List > Subject: Database access > > > Hello there, > > How can I retrieve the data I got from my sql queries to my MS Access > Database? > If for example i queried > > sql("select count(username) from users where username = " $strUsername); > > how can i get the count value? and is my understanding of the sql() > correct? > I can't understand the documentation very well > > and how can i get the data if my sql query retrieves a table of data? > > sql("select * from users"); > or > sql("select username,password from users"); > > Thanks in advance > > Rafferty > > _______________________________________________ > ActivePerl mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > __________________________________________________ Voicemail, email, and fax...all in one place. Sign Up Now! http://www.onebox.com _______________________________________________ ActivePerl mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
