Hi - You need the following skills/tools to do this (it's not too bad):
1) CGI programming (including form handling). Requires the CGI:: modlue. 2) DBI programing (req DBI::). 3) ODBC setup - req DBD::ODBC and you must setup an ODBC source in your windows system to point to your Access 96 db. Of course there are other ways to do your task, but IMHO this is most straightforward. Can you let us know in which area/areas you need help? Aloha => Beau. -----Original Message----- From: Thanatos [mailto:thanatos@;vcnet.com] Sent: Wednesday, October 23, 2002 4:21 PM To: Analbers, Luc Cc: [EMAIL PROTECTED] Subject: Re: question about importing data in MS Access Analbers, Luc wrote: > Hi, > > Can anyone help me? > This is what I try to make: > > I do have a Microsoft Access file on the network. > I would like to give our employees the opportunity to fill in a HTML form > (to be created in Dreamweaver) and send (store) the data to the shared > networkdirectory. > Once this is done, the data should be automatically imported in the database > and after succesfull import the sent data must be deleted automatically. > > So generally it is about sending data (via HTML) to an Access 97 database. > > Anyone solved this problem before? > Who can help me? What do I need to solve this issue? > > Kind regards, > > Luc > > > ------------------------------------------------ > Luc Analbers > Applicatiebeheerder Redactie > Wegener Huis-aan-huis Kranten BV > Houten > *: [EMAIL PROTECTED] > ------------------------------------------------ > > > ------------------------------------------------------------------------ > Hello Luc, There is a perl module called DBD::ODBC. I have never used it but I have been told that you can connect to an Access database and insert records. ( I do this all day using DBD::mysql on a MySQL database ). What you need to do is have your HTML submit to a perl script that connects to the Access database and inserts the data. Hope that helps, Thanatos p.s. You can read about the DBD::ODBC module here: http://search.cpan.org/author/JURL/DBD-ODBC-0.43/ODBC.pm Hope that helps, Thanatos -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
