[mdb-dev] Perl Answer and another Question about spaces in column names

[RI D. <s02...@sm...>]

Hello.

A few days back I posted to ask how you could use mdb-tools command line 
utilities from within perl.  A few folks replied but I didn't really follow 
alot of it, Im not that familar with perl or mdb-tools.  Just bang the 
following snippit of code into your perl script:


open AFILE, "|mdb-sql db1.mdb>fred.txt";

print AFILE <<"ENDOFQUERY" ;

list tables
go
quit

ENDOFQUERY

close(AFILE);

the lines btw print AFILE <<"ENDOFQUERY" ; and ENDOFQUERY are just as you would 
enter them at the command line.  So I hope this helps someone in future.  I am 
guessing these emails are stored somewhere online.

I do have another question.  I want to select all the contents of two columns 
from a table.  But at the moment I can't select anything from the table because 
the table name has an underscore in it!  Anybody know the correct way to format 
such a query?

Kind Regards,

Rob