Re: Get a list of column field names from a MS Access table

On Sat, Feb 28, 2009 at 6:08 PM, Paul M Foster <paulf@quillandmouse.com> wrote: > On Sat, Feb 28, 2009 at 12:41:12AM +0000, Ashley Sheridan wrote: > >> On Fri, 2009-02-27 at 16:58 -0500, Bastien Koert wrote: > > <snip> > >> That'll just return an empty result set, as in empty and with no fields >> output! In MySQL you can do this: >> >> SELECT column_name FROM information_schema.columns WHERE table_name = >> 'table_name' >> >> this might help with doing the same for M$Access? >> > > This is the SQL standard way of doing this. Both MySQL and PostgreSQL > support it. Don't know about MSSQL. > > Paul > -- > Paul M. Foster > Access is not MSSQL, and I'd hardly consider it standard SQL either. :-) To even connect to it from PHP, I think you'd need to either use a generic ODBC library or else the COM or DOTNET libraries to use something like Microsoft's ADO library or similar. Andrew