Create numbered history tables

[HMartin0255]

I have a database that automatically imports an excel spreadsheet and runs it through several queries. I am wondering if it is possible to create a macro so that when it imports it creates a history of the spreadsheet imported. I know this can be done with one spreadsheet but, can it be done so it archives more than one in a numerical order? Can I have it archive up to ten of the previous spreadsheets?

 

[Trevil]

If you're using VBA code for your import, then you could always have it either save using a sequence number (would either require a table with a record that has a value that is incrementes, or you could get a list of the files already saved and either increment or loop), or you could save and use a date/time stamp in the file name.

Learn from the mistakes of others. You won't live long enough to make all of them yourself.