Re: writing to Microsoft Access MDB
Igor Korot <[email protected]> Tue, 25 Mar 2008 11:32:19 -0700 (GMT-07:00)
| Newsgroups | gmane.comp.db.mdb-tools.devel |
|---|---|
| Message-ID | <14331325.1206469939715.JavaMail.root@elwamui-cypress.atl.sa.earthlink.net> |
Hi, Did you create your database or you using the standard access files? Thank you. -----Original Message----- >From: Ketjes <[email protected]> >Sent: Mar 25, 2008 8:38 AM >To: [email protected] >Subject: [mdb-dev] writing to Microsoft Access MDB > >Hi, > >I want to execute an INSERT-query into a Microsoft Access-file. > >I use: >- Debian-Linux as OS (kernel = 2.6.18-4-686-bigmem) >- unixODBC version 2.2.4 >- libmdbtools (debian-package) => mdbtools: version >0.5.99.0.6pre1.0.20050409-1 >- I use Perl to write my scripts > >I can SELECT records from my Access-DB perfectly, but when using INSERT >in a query I always get "syntax error near INSERT" ! I'm quite sure of >the INSERT-syntax itself... > >My question: does this version of mdbtools support writing to Access >MDB-files ? anyone an idea what I'm doing wrong ? > >Kind regards, > >B. > >------------------------------------------------------------------------- >This SF.net email is sponsored by: Microsoft >Defy all challenges. Microsoft(R) Visual Studio 2008. >http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >_______________________________________________ >mdbtools-dev mailing list >[email protected] >https://lists.sourceforge.net/lists/listinfo/mdbtools-dev ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/