Search results

Thank you for your prompt response. I believe the best option would be option 1. I will delete the records. Please let me know how to proceed.

The excel file that we will be importing will be a report that is updated daily with new records. I believe we will be using the same table everytime just importing that report daily into the table. Thank you

Thank you for your response. It would be imported into a new table. These are the following steps i have been doing: Go to File, Get External Data..., and choose import file. Select the specific Excel File I select a series of options. Check the box for the option that indicates the First Row...

I was wondering how to create a macro to automatically import an excel file that updates daily. Once that is imported I would like to automatically run a query without manually entering the joins and other steps associated. Any help would be greatly appreciated. Thank you