Keep It Simple, Stupid | |
PerlMonks |
Extracting data from a pipe delimited text file into a table in Accessby Anonymous Monk |
on May 03, 2003 at 01:39 UTC ( [id://255222]=perlquestion: print w/replies, xml ) | Need Help?? |
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question: I have written the below Perl script to extract data from a pipe delimited text file to an Access database.
I am currently running this script from a batch file which has a single statement: perl perlscript2.txt where perlscript2.txt is the pipe delimited text file which looks like this:
I keep getting an error message: 'DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement'
when I print out $dbh i get HASH along with numbers in brackets (which means the $dbh part works fine right?). Any help on resolving this issue will be greatly appreciated!!! Thanks! update (broquaint): added <code> tags
Back to
Seekers of Perl Wisdom
|
|