PDA

View Full Version : Access and Excel


dotrain4u
Jun 12, 2003, 12:57 PM
Is it possible to import simple information from a spreadsheet in Excel into a pre-existing Access table? If so, how?

ScottGem
Jun 17, 2003, 05:41 AM
Yes its very easy. In the Database tab, you select New, Import. Follow the prompts, one of them will ask if you want to append to an existing table.

You might want to link to the sheet first and then use an Append query to make sure the fields match up right.