Is it possible to get all the column names in a database table?

  • Thread starter Thread starter Showjumper
  • Start date Start date
S

Showjumper

Is it possible to retrieve a table name and then all the column names in
that table from an access database? And then once that is done, then build a
sql insert statement using the retrieved table and columns names?

Thanks
Ashok
 
Study the OleDb CommandBuilder and related classes. These are desgned to
take a SELECT statement and generate insert, update and delete logic
programmatically.

To just get a list of table names, you would use
OleDbConnection.GetOleDbSchemaTable with OleDbSchemaGuid.Tables

--Peter
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Insert Values Of External Table Into Current Data Table 0
insert into a table 1
Retrieve data from Access database and fill data in form 0
Word Create a Phone Book using MailMerge in word 2007 0
Insert or Save file into SQL Server Database Table with C# Examplesand VB.Net Examples 0
What are the steps to fix damaged MDF files in SQL Server? 0

Back
Top