How to List Fields Name in table in Access Using SQLI work in ms access far too much. The only way I know of to do this, would be using vba, and defining for example a recordset, and looping through the fields. Eg dim rst as new adodb. SELECT FROM Some. Table, Current. Project. Connection, ad. Open. Forward. Only, ad. Lock. Read. Only. Note ad. Open. Forward. Only and ad. Lock. Read. Only are the default values. Cursor. Type and Lock. Type arguments, so they are optional here. The string variable ss will contain a comma delimited list of all the column names in the table named Some. Table. With a little reformatting of the logic you should be able to insert this data into another table if you wanted to, then query it out. Here is one consultants experience with converting small to midsized Access JET projects to SQL Server 6. x. I am designing a MySQL Table schema to store the user visit counts stat for shops, I want to make a graph from the table data to show user shop visits per hourday.
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |