Forum Moderators: coopster & phranque

Message Too Old, No Replies

Getting Column Headings from Access

         

Robber

1:40 pm on Nov 29, 2002 (gmt 0)

10+ Year Member



Anyone know of nice tidy way of getting just the column headings for a particular database table using perl and Access?

Cheers

jatar_k

6:59 pm on Dec 1, 2002 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



so what you're saying is no one here is using perl with access?

Robber

9:39 am on Dec 2, 2002 (gmt 0)

10+ Year Member



Looks like it - to be honest I wouldnt have chosen to but we have a client.....

Problem seems to be that the options using other platforms aren't supported, eg.

* sys tables don't seems to have correct information to run a select on

* functions such as SQLColumns aren't supported.

Just had to blag it in the end and take the keys from the hashref.

Cheers