Re: error returned in Win32::OLE module with mdb file's tables and cloumns having whitespace characters in their names.

[strat]

in reply to error returned in Win32::OLE module with mdb file's tables and cloumns having whitespace characters in their names.

Try [-braces around the column names, e.g

my $string = "SELECT [col 1], [col 2], col3 ...";

and then use "col 1" as hash keys, e.g

my $value1 = $RS->Fields("col 1")->value;