SQL Script for importing data

I need to import data from an access database between certain dates (1st sept 2003 and 1st Jan 2004) and place it in an MIS database.

Being quite new to SQL could you please givee me some tips.

regards

colin