How to find all tablefields?

[jarla]

Hi!
Is there an easy way to check what tablefields Access -table have? We have lot of customer -databases with different tables and I need to check what kind of fields database table have. With that information it´s easier to update the table using one "temp-table" and ColdFusion. Or is there any other way to export data straight from "temp-table" to customer´s database? That that export takes all tablefields and their data and then export the data to customer´s database.

 

[obxlefty]

You can use the query.columnList output from a query. It returns a comma delimited list of your table fields.

<cfquery name=&quot;qname&quot; datasource=&quot;ds&quot;>
select * from tablename
</cfquery>

<cfoutput>#qname.columnList#</cfoutput>

From there, you're in trouble with Access. SQL Server and Oracle has commands to create tables within a query. I'm not aware of any way to do this in Access.

Hope this helps,
Mike

 

[jarla]

Thanks a lot! That easy way was just what I needed right now