Is it possible to import simple information from a spreadsheet in Excel into a pre-existing Access table? If so, how?
![]() |
Is it possible to import simple information from a spreadsheet in Excel into a pre-existing Access table? If so, how?
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.
All times are GMT -7. The time now is 09:20 PM. |