Re: Help needed to insert data into MS Access database table........

You are not getting the error message from DBI.

Use $DBI::errstr to print the error.

Update: Also, in your post yesterday, you had 4 tables. No you have one. did you mean to add the additional columns to the insert (assuming you added the identifier column to replace the 4 tables). perhaps you are missing your primary key on the insert?

Update2daveorg nailed the first issue... how about a

use DBI;
[download]

for starters.

Comment on Re: Help needed to insert data into MS Access database table........ Download Code

Replies are listed 'Best First'.
Re: Re: Help needed to insert data into MS Access database table........ by davorg (Chancellor) on Dec 18, 2000 at 22:26 UTC
That won't achive anything as he's not using DBI. This can, of course, be seen as a major problem with the script :-) -- <http://www.dave.org.uk> "Perl makes the fun jobs fun and the boring jobs bearable" - me	[reply]
Re: Re: Re: Help needed to insert data into MS Access database table........ by c-era (Curate) on Dec 18, 2000 at 23:57 UTC
No, but he is using OLE with adodb, so he doesn't need to use DBI.	[reply]
Re: Re: Re: Re: Help needed to insert data into MS Access database table........ by boo_radley (Parson) on Dec 19, 2000 at 01:13 UTC
No, but he is using OLE with adodb, so he doesn't need to use DBI. If that's the case, don't expect $DBI::errstr to report anything, ever, Surya. That variable relies on you using DBI for your database access. There might be one for OLE, but I dunno.	[reply]