How to Import data from Excel into a single table

[Rich]

Hello,

I need to import data from an Excel spreadsheet into a table. This table
will contain info related to certificates. For a given server, the table
will have a row for each certificate on that server.

This is what I am hoping to accomplish.

1. User must input a server name.
2. On_Click, display a File Open dialog box so user can navigate to and
select the spreadsheet file.
3. Import the data.

Is there a way to call a File Open dialog box? If so, how?
What is the code required to execute the actual import?

TIA,
Rich

 

[Piet Linden]

Hello,

I need to import data from an Excel spreadsheet into a table.  This table
will contain info related to certificates.  For a given server, the table
will have a row for each certificate on that server.  

This is what I am hoping to accomplish.

1.  User must input a server name.
2.  On_Click, display a File Open dialog box so user can navigate to and
select the spreadsheet file.
3.  Import the data.

Is there a way to call a File Open dialog box?  If so, how?
What is the code required to execute the actual import?

TIA,
Rich

use a combobox for the server name. probably store those in a table,
so you'd just use a query against that table to get the servers you
want.

then use the OpenSaveFileAPI at Access Web for the file Open...
http://www.mvps.org/access/api/api0001.htm

 

[gllincoln]

Hi Rich,

If you are using Access 2007, take a look at the Application filedialog
property.

For details and sample code to look over, check out this URL.

http://msdn.microsoft.com/en-us/library/bb213476.aspx

Hope this helps,
Gordon

..