Re: writing to Microsoft Access MDB

Igor,

I created the access file myself...

I created one table (table1) with one field (test) of type "long
integer". I tried to insert one value with the SQL-statement: INSERT
INTO tabel1 ( test ) VALUES ( '1' );

I tried all variants I can imagine...

B.


On Tue, Mar 25, 2008 at 7:32 PM, Igor Korot <[email protected]> wrote:
> 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/