I have built a temporary table that will eventually be used to import information into a permanent table.
I will be importing (or appending, inserting) into the temp table, info contained in a table created from outside info where the fields are all note fields. This table is already in the database. I will only be using certain fields to go into the temp table. Here is the question. Since I will have more fields in the temp table than the number of fields I will insert, what is the best method for doing this? Jim

