LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Read Fieldnames with SQL from Access2000

I like to read the fieldnames from a access2000-table. Does anybody know the SQL-commands?
0 Kudos
Message 1 of 2
(2,500 Views)
SQL commands are relatively universal, whether you're using Access or MySQL or Postgresql. "SELECT database_name" will give you a table of all the fields and values within that database. The entire SQL command library is available on line; however, if you're using the VB tools inside Access, you don't really need to know SQL per se. I'd go through the Access help files first, to get a list of all the queries you're likely to need.

Hope this helps

Eric
Eric P. Nichols
P.O. Box 56235
North Pole, AK 99705
0 Kudos
Message 2 of 2
(2,500 Views)