1 Replies - 2104 Views - Last Post: 07 June 2012 - 09:32 AM

#1 fatbunny  Icon User is offline

  • New D.I.C Head

Reputation: 3
  • View blog
  • Posts: 33
  • Joined: 09-February 09

reading columns information / table structure

Posted 05 June 2012 - 10:17 AM

On an MS SQL Server I can read column information

SELECT 
   ORDINAL_POSITION
  ,COLUMN_NAME
  ,DATA_TYPE
  ,CHARACTER_MAXIMUM_LENGTH
  ,IS_NULLABLE
  ,COLUMN_DEFAULT
FROM   
  INFORMATION_SCHEMA.COLUMNS 
WHERE   
  TABLE_NAME = 'MyDataTable'



Is it possible to do something similar for MS Access ?
Is This A Good Question/Topic? 0
  • +

Replies To: reading columns information / table structure

#2 June7  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 104
  • View blog
  • Posts: 904
  • Joined: 09-December 08

Re: reading columns information / table structure

Posted 07 June 2012 - 09:32 AM

Only way I know is with VBA. Review:
http://www.everythin...n-VBA-%28DAO%29
http://www.java2s.co...dproperties.htm
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1