Re: writing to Microsoft Access MDB

I hope it's just an E-mail typo...
You saying you created the table "table1", but trying to insert in "tabel1".

Thank you.

-----Original Message-----
>From: BonzaiBoy <[email protected]>
>Sent: Mar 25, 2008 4:08 PM
>To: Igor Korot <[email protected]>
>Cc: [email protected]
>Subject: Re: [mdb-dev] 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/
>_______________________________________________
>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/