RE: exporting an excel file into an access table

OK. In that case, you want to do the following. Link or import the Excel file.
You also need the following code:

Dim dbNew As Database

Set dbNew=OpenDatabase ("path and remote database name here in quotes",
there's more that's necessary, including passwords. See the OpenDatabase
method for details. Make sure to read the example for necessary detailed
coding.

Once you have the remote db opened, use an append query to do its job.
Close all.

Helpful?

Sam

asset wrote:
Thanks SAM

Read it , but it seems this just copies the file to the required destination.

The problem for me is exporting the Excel file from my PC
and appending ( or importing ) this data into an Access97 database table held
in another
location. Its not just a question of copying the file to another PC.

This entire operation would take place by clicking on a command button
located in
my Access form designed especially to carry out this operation.

Sorry, I misunderstood.

[quoted text clipped - 8 lines]

Sam

To do what you want is simple. First of all close the Excel workbook. Open
the Access database, click on File-->Get External Data-->Import. On the
[quoted text clipped - 20 lines]
All this is doing is creating a table with that path as its name in my own
Access database?

--
Sam

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200603/1
.