How to Import data from Excel into a single table

  • Thread starter Thread starter Rich
  • Start date Start date
R

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
 
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
Click to expand...

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
 
Back
Top