Microsoft Access: How do I concatenate several logs into one log?

[Pulp]

Could someone please help me with a question I have dealing with Microsoft Access? I am wondering if someone knows what steps I would need to take to concatenate numerous logs from a server into one log? If someone could help me out with this question it would be greatly appreciated.

Thank You,
Pulp

 

[SBendBuckeye]

Assuming that all of the logs have the same format and that you want to add old logs 1 thru 3 into new log you could do something like the following:

INSERT INTO tblNewLog
SELECT tblOldLog1.* FROM tblOldLog1;

INSERT INTO tblNewLog
SELECT tblOldLog2.* FROM tblOldLog2;

INSERT INTO tblNewLog
SELECT tblOldLog3.* FROM tblOldLog3;

Good Luck!

 

[Pulp]

Thanks a lot!! I'll give it a try!!!

Pulp