Create table from array

[itchyII]

Hi everyone,
I have a database consisting of multiple tables and records that I need to condense certain information into one new table. It will be something that I will have to run on a regular basis, perhaps once a month. I have determined that the best way for me to do this is compile all the information from the various tables into an array. ( in order to do this I will have quite a few functions sifting through records) Once I have the array, I would simply like to dump it in a table. Every month, when I run the script, I would delete the existing table and re-build it. What is the easiest method to dump the data from my array into a table? I have used DAO but I am not too familiar with ADO. I have never created a table in code before! Looking for your advice!

Access 2000

Itchy

 

[fredericofonseca]

To create a table just issue a normal SQL (create table ....).

Probably no need to destroy the table. a "truncate" would probably be faster.

There are a few examples of ADO on these forums, and if you have access to MSDN, there are plenty of examples with ADO.

Search first of all, and then post specific questions.

It is not hard if you are used to DAO/RDO.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com