|
»
»
writing to Microsoft Access MDB
|
View:
New views
5 Messages
—
Rating Filter:
Alert me
|
 |
writing to Microsoft Access MDB
by PeterPan
::
Rate this Message:
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 mdbtools-dev@... https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
|
|
|
|
Re: writing to Microsoft Access MDB
by PeterPan
::
Rate this Message:
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 <ikorot@...> wrote: > Hi, > Did you create your database or you using the standard access files? > > Thank you. > > > -----Original Message----- > >From: Ketjes <ketjes@...> > >Sent: Mar 25, 2008 8:38 AM > >To: mdbtools-dev@... > >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 > >mdbtools-dev@... > >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 mdbtools-dev@... https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
|
|
|
|
Re: writing to Microsoft Access MDB
by PeterPan
::
Rate this Message:
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 <ikorot@...> 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 <ketjes@...> > >Sent: Mar 25, 2008 4:08 PM > >To: Igor Korot <ikorot@...> > >Cc: mdbtools-dev@... > >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 <ikorot@...> wrote: > >> Hi, > >> Did you create your database or you using the standard access files? > >> > >> Thank you. > >> > >> > >> -----Original Message----- > >> >From: Ketjes <ketjes@...> > >> >Sent: Mar 25, 2008 8:38 AM > >> >To: mdbtools-dev@... > >> >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 > >> >mdbtools-dev@... > >> >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 > >mdbtools-dev@... > >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 mdbtools-dev@... https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
| Free Forum Powered by Nabble | Forum Help |
