When I try to import a spreadsheet the "to an existing table" 
option is disabled. Anyone know what would cause this?
Paul

Paul,

<< When I try to import a spreadsheet the "to an existing table" option is 
disabled. Anyone know what would cause this? >>

Hmmm... an Access table is very specific about how many fields it 
contains, the datatypes of the fields, the validation rules, etc.  My 
guess is Access doesn't want to risk trying to import an Excel spreadsheet 
that, for example, contains 25 columns into an Access table that has only 
ten fields.  Where will the other 15 columns go?!  So to play it safe, it 
will only allow you to import the Excel spreadsheet into NEW table.

From there, you can make an update query, add the two tables to it, set 
the relationships in the query between the two tables, and then run it to 
populate the desired table.

Greg

Link the spreadsheet to a new table and then use append query to do what 
you want.


> When I try to import a spreadsheet the "to an existing table" 
option is disabled. Anyone know what would cause this?
Paul