Example of Programmatic Import of an Excel Work*** to an Access Table

From: Don (someone_at_somewhere.net)
Date: 03/12/05 

Date: Sat, 12 Mar 2005 09:52:42 -0500

What built-in functions should I be looking for to programmatically
imporrting an Excel work*** into an Access (2003) table? There does not
seem to be an "import" function per se (or I missed it!). There was a
reference to an SQL string in a posting in
microsoft.public.access.externaldata. However, it was not clear how the
connection to the spread*** itself was made.

In short, my goal is to allow the user to pick the desired Excel file (.xls)
and then the program import the data into a table. The spread*** is
relatively simple having one work*** and is fixed format (i.e. the columns
do not vary from instance to instance).

Any suggestions will be greatly appreciated!

Thanks!

Don