Is it an option to change your data access method to 'SQL command' rather than 'Table or View', and write the insert statement yourself?