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/