Automatically importing Excel to Access XP

T

Ted

Hi all,

I'm using Access XP Developer's Edition to create a runtime application.
In the application I have to give the user the ability to import an Excel
spreadsheet. Does anyone have any idea how to do it programmatically
thru code? It's obviously easier with the full version of Access by File -
Get External Data - Import but you can't do that with the Runtime Version
of Access and I would rather the user have the ability to import the file
with the click of a button.

TIA
Ted
 
J

John Nurick

Hi Ted,

The VBA equivalent is DoCmd.TransferSpreadsheet which AFAIK is available
in the runtime version. If you want the user to be able to select the
file to import, use Application.FileDialog (or for compatibility with
earlier versions, the code at www.mvps.org/access/api/api0001.htm
 
Top