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/