title: Exporting data from Access to existing SQL Server DB tables?
body: <p>I have created a DB with empty tables in SQL Server, and created the relationship between all of those tables. 
  A DB in Access with different kinds of tables (compared to the ones in SQL Server) holds a lot of data. I want to be able to insert the data existing in Access to my tables in SQL Server. </p>
  
  <p>Since the tables in the Access DB and SQL Server DB is nowhere near alike, I can't just using an import/export wizard directly. Should I let the wizard create a new table in SQL Server, and use <code>INSERT INTO</code>, to move the data from this temporary table to my actual tables? Is there an easier method to do this? </p>
  
  <p>Also, when exporting data from one DB to another, how do I make sure to keep information together? For example, in the Access DB there is mainly one big table with all information about the products, including suppliers. I wanted to make this more normalized in SQL Server, creating a table for product information, and a table for suppliers - to combine this information, I made a third table with a FK to suppliers, and a FK to products, and information regarding those two together. </p>
  
  <p>Is there a clever way to insert the correct product ID and the correct supplier ID in this third table when exporting data? </p>
  
  <p>Thanks a lot! </p>