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.
Tom Gahagan
Alliance
Computer Solutions
"Music, like sex, is much too important to be left to professionals."
Robert Shaw