>Hi Dan,
>
>...........Actually, it has to been programatically. This is for a web app. The user will click a link to import table as "Access". Behind the scenes in code we will create the access table and then send the table down the wire.
>Dan
>
>There are two ways to proframatically create Access tables. Through DAO and DDL (data definition lanquage) queries. In DDL you can use the create table to create a table schema, alter table to modify and exisitng talbe schema, and create index to create a new index.
>
>The create talbe syntax is:
>
>CREATE TABLE table (column1 type1 [(size)] [column2 type2 [(size2)] etc
>
>like... create table myTable (mname text (35), myaddress text (35), myzip long)
>
>For the DAO you should read Chapter 6 of Access 97 Developers Handbook by Litwin, Getz, Gilbert published by Sybex.
>
>If it is Access 2000 you may want to go with ADO instead of DAO. I hear it is faster.
>
>Hope this gets you started.

Thanks, I will check that out.