import Excel spreadsheets

Guest · Nov 11, 2003

I have a client who will need to be able to import spreadsheets into an Access table. He's not very computer knowledgeable so I'd like to automate as much as possible.

The TransferSpreadsheet command requires a file name. Is there a way to automate the import process so that the file name can be obtained from the user at run time?

Thanx...

John Nurick · Nov 11, 2003

Hi Jeff,

There's code at http://www.mvps.org/access/api/api0001.htm for using the
standard Windows File Open dialog in Access 97 or later. Access 2002 or
later also have a built-in FileDialog opbject.

import Excel spreadsheets

Guest

John Nurick