writing to Microsoft Access MDB

Ketjes <[email protected]> Tue, 25 Mar 2008 16:38:35 +0100
Newsgroups gmane.comp.db.mdb-tools.devel
Message-ID <[email protected]>
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/