make table query - Access 2000 on Windows 2000

  • Thread starter Thread starter Diann
  • Start date Start date
D

Diann

Is there a way that I can use the make table query,
selecting some fields from one table and inserting new,
blank fields into new table?

I will be uploading information on a weekly basis new test
candidates to a national organization. There are
approximately 40 optional fields that I will not be using
but I am required to have the fields in the uploaded
version as placeholders. I don't want to put useless
fields into my main table.

Any ideas? My brain is fried at the moment. Thanks.
 
Use a query as the source for the make table query.

SELECT tableCandidates.*, "" as Expr1, "" As Expr2, ...
FROM TableCandidates

Save that and then use it as the basis of your make table query. Or do it all
in one. This sample makes text fields with a zero-length string.

SELECT TableCandidates.*, "" AS Expr1, "" AS Expr2 INTO tblExport
FROM TableCandidates;

The alternatives are
Design your export table and keep it, then delete existing records and append
to it

Make a query and export the query directly without ever putting the data into
a table.
 
Back
Top