TheToeOfPooh
Active Member
- Joined
- May 21, 2004
- Messages
- 254
I currently link new excel worksheets on a dialy basis.
I then use a variety of Append Queries to manipluate the data and produce reports.
Can anyone recommend a way of automating the process by which a new table is selected by an Append Query.
e.g. In the following I would like to have perhaps an Input box which says
"Enter new Table".
The user would then enter e.g Julyprn15.
All refferences to July14 would then be altered and the Query run.
Sample of current code taken using SQL View.INSERT INTO tblTemplateYESTERDAY ( WFlowJobNo, JESJob, JESJobNo, System, Account, Owner, FormType, Class, FormDef, Pages, Copies, Printer, StartDate, StartTime, EndDate, EndTime, PrintedSheets, PagesProcessed, PrintError, Incomplete, AReprint )
SELECT Julyprn14.Field1, Julyprn14.Field2, Julyprn14.Field3, Julyprn14.Field4, Julyprn14.Field5, Julyprn14.Field6, Julyprn14.Field7, Julyprn14.Field8, Julyprn14.Field9, Julyprn14.Field10, Julyprn14.Field11, Julyprn14.Field12, Julyprn14.Field13, Julyprn14.Field14, Julyprn14.Field15, Julyprn14.Field16, Julyprn14.Field17, Julyprn14.Field18, Julyprn14.Field19, Julyprn14.Field20, Julyprn14.Field21
FROM Julyprn14;
Any help would be very much appreciated.
Bernard
I then use a variety of Append Queries to manipluate the data and produce reports.
Can anyone recommend a way of automating the process by which a new table is selected by an Append Query.
e.g. In the following I would like to have perhaps an Input box which says
"Enter new Table".
The user would then enter e.g Julyprn15.
All refferences to July14 would then be altered and the Query run.
Sample of current code taken using SQL View.INSERT INTO tblTemplateYESTERDAY ( WFlowJobNo, JESJob, JESJobNo, System, Account, Owner, FormType, Class, FormDef, Pages, Copies, Printer, StartDate, StartTime, EndDate, EndTime, PrintedSheets, PagesProcessed, PrintError, Incomplete, AReprint )
SELECT Julyprn14.Field1, Julyprn14.Field2, Julyprn14.Field3, Julyprn14.Field4, Julyprn14.Field5, Julyprn14.Field6, Julyprn14.Field7, Julyprn14.Field8, Julyprn14.Field9, Julyprn14.Field10, Julyprn14.Field11, Julyprn14.Field12, Julyprn14.Field13, Julyprn14.Field14, Julyprn14.Field15, Julyprn14.Field16, Julyprn14.Field17, Julyprn14.Field18, Julyprn14.Field19, Julyprn14.Field20, Julyprn14.Field21
FROM Julyprn14;
Any help would be very much appreciated.
Bernard