Re: writing to Microsoft Access MDB

I'm sorry... unfortunately that's only a typo in my e-mail. The name
of the table is table1 and in the INSERT-statement it should be table1
too...

B.


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