In a previous job, we had Perl scripts which could interact with a SQL
DB using Perl's DBI module We were able to programmaticall y add,
delete and query tables using this module.
Is it possible to do something similiar with Perl? (and not VBA)???
The reason I ask is because I want to use Access instead of MySQL
because
with Access, I can design Forms and Queries to display data relatively
quickly. With MySQL, I'd have to use third party or open source SW.
I am planning on grabbing baseball statistics from websites using Perl
(the Perl LWP module). With the raw data, I will process it and then I
want to use Perl to add the data to the MS Access DB. This might mean
adding records to a table to modifying existing records in a table. Is
there a way to interfact with Access DB using Perl?
Doomster 6 2538
You can use the ADO library with Peral, and thus you can use a mdb.
You will have to have JET installed on the pc, and having done so, then you
can use the DBI module...
"JET" used to be a separate download in the download section. I don't know
where it went to, but if you got ms-access installed, then you got JET
installed, and should thus be able to use a mdb file with perl.
Just do a web search for
perl ado jet
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada pl************* ****@msn.com http://www.members.shaw.ca/AlbertKallal
Jet is installed and updated with Windows.
You can connect to Jet using an ODBC or OLEDB
connector (No native JDBC available), or using the
ADO or DAO COM objects.
So you can connect using Perl's DBI - or you have
a choice of other methods.
(david)
"Doomster" <do******@gmail .com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. . In a previous job, we had Perl scripts which could interact with a SQL DB using Perl's DBI module We were able to programmaticall y add, delete and query tables using this module.
Is it possible to do something similiar with Perl? (and not VBA)???
The reason I ask is because I want to use Access instead of MySQL because with Access, I can design Forms and Queries to display data relatively quickly. With MySQL, I'd have to use third party or open source SW.
I am planning on grabbing baseball statistics from websites using Perl (the Perl LWP module). With the raw data, I will process it and then I want to use Perl to add the data to the MS Access DB. This might mean adding records to a table to modifying existing records in a table. Is there a way to interfact with Access DB using Perl?
Doomster
"Doomster" <do******@gmail .com> wrote in
news:11******** **************@ z14g2000cwz.goo glegroups.com: In a previous job, we had Perl scripts which could interact with a SQL DB using Perl's DBI module We were able to programmaticall y add, delete and query tables using this module.
Is it possible to do something similiar with Perl? (and not VBA)???
The reason I ask is because I want to use Access instead of MySQL because with Access, I can design Forms and Queries to display data relatively quickly. With MySQL, I'd have to use third party or open source SW.
I am planning on grabbing baseball statistics from websites using Perl (the Perl LWP module). With the raw data, I will process it and then I want to use Perl to add the data to the MS Access DB. This might mean adding records to a table to modifying existing records in a table. Is there a way to interfact with Access DB using Perl?
Albert has provided you with a lead on this, so I won't address it.
I just want to be sure that you understand (you seem to) that you
will only be able to interact with the tables and queries, and not
with the forms and reports, through Perl.
Well, I guess it would be theoretically possible to use COM from
Perl, but it would be every messy, and very unlikely to be allowed
by an ISP.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
David,
I just want to use Perl to get data from websites (baseballs stats),
then input them into the DB. This I want to automate because inputting
data into the MS Access DB is labor intensive.
The queries and using forms will be done manually.
This works fine. I just got to get it to work with JET.
Trust me, there will be further questions from me on this board
:-)
Doomster
"Doomster" <do******@gmail .com> wrote in
news:11******** **************@ z14g2000cwz.goo glegroups.com: I just want to use Perl to get data from websites (baseballs stats), then input them into the DB. This I want to automate because inputting data into the MS Access DB is labor intensive.
The queries and using forms will be done manually.
This works fine. I just got to get it to work with JET.
Trust me, there will be further questions from me on this board
Well, if they are about desiging your Access application, this is
the right place to ask.
But if it's about how to use Perle to scrape websites, you're not
going to find much help here, as most of the issues you'll encounter
are likely to be peculiar to Perle's way of working with whatever
data interface to your Jet data you use (ODBC or ADO). The Jet end
of that is pretty much completely trivial, with hardly any problems
specific to Jet that you'd likely find help with in this newsgroup.
I would say you'd be better off asking those questions in a Perle
forum, where it's quite likely that people have worked with data
stored in Jet MDBs.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
> Well, I guess it would be theoretically possible to use COM from Perl
$objConn = Win32::OLE->new('ADODB.Con nection');
$objConn->open($strConn) ;
$objRS = $objConn->execute($strSQ L);
(david)
"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:Xn******** *************** ***********@216 .196.97.142... "Doomster" <do******@gmail .com> wrote in news:11******** **************@ z14g2000cwz.goo glegroups.com:
In a previous job, we had Perl scripts which could interact with a SQL DB using Perl's DBI module We were able to programmaticall y add, delete and query tables using this module.
Is it possible to do something similiar with Perl? (and not VBA)???
The reason I ask is because I want to use Access instead of MySQL because with Access, I can design Forms and Queries to display data relatively quickly. With MySQL, I'd have to use third party or open source SW.
I am planning on grabbing baseball statistics from websites using Perl (the Perl LWP module). With the raw data, I will process it and then I want to use Perl to add the data to the MS Access DB. This might mean adding records to a table to modifying existing records in a table. Is there a way to interfact with Access DB using Perl?
Albert has provided you with a lead on this, so I won't address it.
I just want to be sure that you understand (you seem to) that you will only be able to interact with the tables and queries, and not with the forms and reports, through Perl.
Well, I guess it would be theoretically possible to use COM from Perl, but it would be every messy, and very unlikely to be allowed by an ISP.
-- David W. Fenton http://www.bway.net/~dfenton dfenton at bway dot net http://www.bway.net/~dfassoc This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Marta |
last post by:
Hi all!
I would to study a web programming language to create a PHP script
(output.php) that, given the following
input page (input.htm) where the user select the weight and volume of a
package to be shipped, returns the prices of various couriers ("yellow",
"blue" and "black").
Really is PHP my best choice? ASP is much more complicated? and what about
Perl?
|
by: Joe Cheng |
last post by:
I'm curious about something... many Artima.com members who have a Java
background and learned Python have come to the conclusion that Java and
Python are highly complimentary languages. They would never consider
filling the place Java has in their toolbox with Python, but recognize there
are many tasks where it really pays to add Python to the mix.
I want to ask you hard-core c.l.p Pythonistas: Do you use Python for
everything? (and...
|
by: Jonas |
last post by:
Good day, I have a .bat script I'm invoking thru a cgi script (PERL)
with (NT/IIS) on a internal network. The .bat script is having
problems accessing network drives, it keeps saying "Invalid drive
specification". I have tried to access the drives like this:
\\servername\share\...... and like this: G:\.....
When I change the cgi script to a regular perl script and invoke it
from the command line it works fine...
When I change the path...
|
by: Jerome |
last post by:
Hi, I'm a bit confused ... when would I rather write an database
application using MS Access and Visual Basic and when (and why) would I
rather write it using Visual Studio .Net?
Is it as easy in Visual Studio to create reports and labels as it's in
Access?`
The advantage of VS.net is that not every user needs Access, right? And
that would eliminate the Access version problem as well I guess.
|
by: BigDaDDY |
last post by:
Um yeah....In case you haven't figured it out, Microsoft sucks. I'm going
to be kicked back in my chair eating popcorn and watching football 10 years
from now, while all you clowns are scrambling to rewrite all your code
because Microsoft upgraded all their crap and nothing you wrote 10 years
earlier works. It doesn't take a rocket scientist to figure out that
Microsoft is unreliable. Try opening an Excel 95 spreadsheet you wrote in...
| |
by: Pecanfan |
last post by:
I've got quite a large database which is totally form-driven at the moment.
I now need to allow multiple users access to various parts of it and,
frankly, I'm not prepared waste my time with Access's inbuilt Workgroup
'security features' - it just seems way too clunky. I figured a more
sensible move would be to port over to SQL and drive it from a nice web
front end. Unfortunately my MS SQL experience is pretty much nil and my web...
|
by: Kanthi Kiran Narisetti |
last post by:
Hi ALL,
I am new to C and programming . I need suggestions for the IDE to be
used as a begginer and should I start on Windows or Linux ??
I am also looking for resources for C programming on Internet with
examples on each concept.
I appreciate if any one can help me in this regard.
|
by: stylecomputers |
last post by:
Hey guys,
I am absolutely new to Linux programming, with no w######s programming
experience except a small amount of C++ console apps.
Reasonably new to Linux, BSD etc, got good sound networking base of
knowledge and dont have any problem working the command line etc.
I want to learn a language that I can use in my networking duties that
is most likely to be of use to me. I have a few choices I can think of
being:
|
by: deko |
last post by:
For building Windows desktop apps, the clear favorite is C#. But my clients
can't afford to buy Microsoft products. So I need to develop software for Linux
users and web applications.
In the open source world, what is the programmer's language of choice?
Judging by the number of members in each of these
http://www.google.com/Top/Computers/Programming/Languages/Open_Source/ user
groups, it looks like the top 3 open source languages...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |