Dear Tux Thanks for your reply this is how I connect to the CSV database
use DBI;
...
#MS Windows path to files
my $fpath="G:\\in";
#LINUX server paths
#my $fpath="/users/excel/in";
my $csvfile="Trx_24Aug2012_0409.csv";
my $cellh = DBI->connect("DBI:CSV:f_dir=$fpath;csv_eol=\n;");
#associate csv file with tablename
my $fname=$fpath.'/'.$csvfile;
$cellh->{'csv_tables'}->{'CELLS'} = {'file' =>$fname};
my $sql="select * from CELLS";
my $stcellh = $cellh->prepare($sql) or die "$DBI::errstr\n";
$stcellh->execute() or die "$DBI::errstr\n";
my $colunmcount = $stcellh->{NUM_OF_FIELDS};
print "$colunmcount\n\n";
$stcellh->finish();
Thanks again
Polelo
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|