使用Guids维护数据库中的键与使用整数的另一个键之间的数据库关系

I'm trying to write an application that will take the information out of a SQL Server database, load up the object models via a webservice, and then pass that information into an Access DB, which is based on a different schema than the SQL Server database, but the information contained is the same (so I assume this would be akin to an ETL process). The problem that I'm running into is that the Primary Keys in the database I'm pulling the information (SQL Server) are GUIDs whereas the database I'm putting them into (Access) are INTs. So for example:I'm trying to write an application that will ta