Bring in an Excel file

[Cardinal]

I have a monthly Excel file that I have to open in Excel, perfom some
sorts and deletes, then create some equations on what remains. I know
that I could speed things up by running an Access query on the data
instead. Is there a way I can create an option so that I can browse
for the file in order to bring it into Access, then automatically kick
into an import? If I could do this then I could eliminate the steps of
importing it through the import wizard. Then hopefully I can tie it
together with the query making it kind of a one step solution.
Thanks very much.

[fredg]

On 2 Apr 2007 14:26:14 -0700, Cardinal wrote:

I have a monthly Excel file that I have to open in Excel, perfom some
sorts and deletes, then create some equations on what remains. I know
that I could speed things up by running an Access query on the data
instead. Is there a way I can create an option so that I can browse
for the file in order to bring it into Access, then automatically kick
into an import? If I could do this then I could eliminate the steps of
importing it through the import wizard. Then hopefully I can tie it
together with the query making it kind of a one step solution.
Thanks very much.

If it's always the same Excel file, you can use the
DoCmd.TransferSpreadsheet method to import or link to the spreadsheet
and range.
Then you can use the table in your query as you would any other table.

If you need to browse for the file, you can find the code needed at:
http://www.mvps.org/access
look in the API section.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail