Import Excel File

G

George

I have many Excel spreadsheets that contain data that I want to import into an Access table. I am using the File/Import/Get External Data option which launches a wizard. I answer all of the prompts the same way, so I want to use a macro instead. (1) What is the difference between using a macro and writing a subroutine in a module? (2) What commands / options do I use to simulate the wizard? For example, after I select the excel workbook, I always select the "Data" worksheet, indicate that the first row contains header info, import the data to an existing table, and click "finish" to end. I want to loop through all of the Excel workbooks in a directory and import them all into one table

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Viso Wizard no launching? 0
Need Help with Macro Security 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Embed the same Excel multiple times 0
Consolidation Table from Different Excel Tabs with Different Format 1
Visio to Excel 0
Visio 2010 Pro not showing Org Chart menu 0
Excel - Wich Function should I use? 1

Top