How do i find out the number, names and datatype of fields in an Access table.....using code.....
Arunabh Nag
0
Light Poster
Recommended Answers
Jump to PostDataTable class members is the answer.
Jump to Postwhy not just google for what he told you?
i straight came to http://msdn.microsoft.com/en-us/library/system.data.datatable_members.aspx
Jump to PostHi
the most easiest way is via DAO
- add reference to ms DAO (3.6)
- set vars for database and tabledef and field
dim db as dao.database, dim tdf as dao.tabledef
- get the current database: set db = currentdb()
- get the tabledef as object: set tdf = …
Jump to PostArunabh Nag: Here is the C# code I use to enumerate tables and columns. Let me know if you have trouble translating it and I will get back with you tomorrow. I figure a C# answer today is better than a VB.NET answer tomorrow :)
using System; …
All 16 Replies
kvprajapati
1,826
Posting Genius
Team Colleague
Arunabh Nag
0
Light Poster
GeekByChoiCe
152
Practically a Master Poster
Featured Poster
kvprajapati
commented:
Well said.
+11
HuubVanOers
0
Newbie Poster
sknake
1,622
Senior Poster
Featured Poster
sknake
1,622
Senior Poster
Featured Poster
Arunabh Nag
0
Light Poster
Arunabh Nag
0
Light Poster
Arunabh Nag
0
Light Poster
sknake
1,622
Senior Poster
Featured Poster
Arunabh Nag
0
Light Poster
sknake
1,622
Senior Poster
Featured Poster
Arunabh Nag
0
Light Poster
Arunabh Nag
0
Light Poster
Arunabh Nag
0
Light Poster
SadiSerdari
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.