Import data from another source

[brmikwen]

Hello,

I have just registered. So first, hello everyone!

I am needing to import a lot of data into Access and wonder how to do this with an Excel file. Been looking around. Someone has an idea?

Cheers.

 

[Mr. B]

First, welcome to the forms.

If you are wanting to do this manually, take a look at the File/Get External Data/Import .. from the File menu. Change the "Files of type" to "Microsoft Excel (.xls), locate your file and follow the prompts.

If you are needing to do this through automation, take a look at the TransferSpreadsheet method.