Do you mean you want import data in an excel spreadsheet into an existing
table in access? Import and Export are different things, so it is important
to know the difference.
What version of Access are you using? I am on 2003 and do that regularly.
> I want to export into a table from Excel but the export into an existing
> table is disabled. How do I export into an existing table.
Ron2006 - 02 Jun 2006 19:33 GMT
Access needs to do the IMPORT instead of Excell doing the EXPORT.
Klatuu - 02 Jun 2006 19:43 GMT
I know what he needs to do, but from the incoherency of his post, it is
difficult to understand what he is trying to do.
> Access needs to do the IMPORT instead of Excell doing the EXPORT.