Linking an existing form to new Table

[Cwire]

Each month I receive a new excel spreadsheet (alpha Roster), Last month I created a form so that I can track certain things off of the Table (spreadsheet), I just received the new Spreadsheet for this month and was wondering if I can use the existing form and how hard it is to link it to the new spreadsheet? Is that even possible? I don't want to have to re create the form every month, I would like to just bring the new alpha roster in and be ready to work.

Thank you in Advance for any advice you all can share.

 

[plog]

This is more of a table/data issue and not a form issue. The form should be based off just one table, the data you get each month should go into that table. You shouldn't have MyTable_January, MyTable_February, ...etc. Instead you should have MyTable with a field that designates which month the data is from.

That way the form never needs editing (automatic or manual). You simply load your new data into MyTable and its available in the form.

 

[Cwire]

Well there's the rub, the roster that I get every month has all the same columns and rows as the spreadsheet the month before, but as folks information change, duty stations, retirements, additions of new employee's etc. I really wanted my form to show what is on the spreadsheet with only the information I have put on the form. I don't need to review every column on the roster just certain things. I think I'm a bit confused but that wouldn't be the first time that has happened. The roster I get every month has over 1000 rows and I only need about 100 of the rows that are scattered throughout the spreadsheet, so that is why I created the form so that I could "Pull" out the specific information I'm looking for and search the spreadsheet by using the search for file so I'm not running all over the spreadsheet pulling out info. Does that make sense?

 

[plog]

Not really. I don't know what you are trying to accomplish. Honestly, if the only purpose of the form is to aid you in identifying records, it may not be necessary at all. The entire process might be able to be made more efficient.

Can you explain the situation better? Don't reference your database at all. Just tell me what you get and what you are trying to end up with.

 

[JHB]

...I just received the new Spreadsheet for this month and was wondering if I can use the existing form and how hard it is to link it to the new spreadsheet? .

I'm sure when you created your form you should identify from where the data should come from, so if open your form in design view and change the form's recordsource to the new data you've got, it would like to work.
But else plog has right.