Hi,

I am relatively new to Access so play nice...

I have a requirement to import regular data into Access and then do a series of queries on the data. I have got quite a long way with it but I am stuck on the following;

I need to add some fields to a table (PageExtent, Runcode and MailsortTrigger) and then populate these fields with data. I can't find any other way apart from manually adding the fields to the table first then running the update queries as individual queries. Is there a better way of doing this?

Thanks in advance...

Richard

UPDATE table SET PageExtent = "E18";

UPDATE table SET RunCode = "testR";

UPDATE table SET table.MailsortTrigger = "0";