How do I query a columns data type in access 2003?

Question

I am looking for a way to get the data type of a column given the table that it is in and the name of the column. I have seen other answers refer to the MSysIMEXColumns table but my Access database does not have that table. I am using Access 2003 if that helps any.

I would like to get the result into my LUA code as a hash table so that before inserts or lookups I can look up the data type of column. Basically it's so that I can determine if field needs quotes around it or not.

LuaSQL is being used to access the access database.

Any help or direction is appreciated

Are you looking to get the result in code? If yes - where is this code running; what language? If no - please clarify. — G. Stoynev, Apr 25 '13 at 13:00
Are you using [LuaSQL](http://www.keplerproject.org/luasql/) to connect to the database? — Gord Thompson, Apr 25 '13 at 13:58

score 2 · Accepted Answer · answered Apr 25 '13 at 14:42

2

The LuaSQL cursor object documentation here suggests that you should be able to use

cur:getcoltypes()

to return "a list (table) of column types".

answered Apr 25 '13 at 14:42

Gord Thompson

116,920
32
215
418

How do I query a columns data type in access 2003?

1 Answers1