Import partial Excel spreadsheet into Access empty table
Posted on 2007-11-13
I have a table in access with 15 fields. The table is empt I- no data yet. I have a spreadsheet that has 22 columns, 10 of the columns match 10 of the 15 columns in the Access table exactly. I want to import just the data from just the 10 columns of the spreadsheet. What is the best way to do this and how. Can I just import it directly into the Access table or do I have let the import create a new table and then append this new table to the other table where I really want the data. I guess what I'm saying is what is the best way to handle importing a spreadsheet table where only part of the spreadsheet matches part of the table exactly.