Importing into access from multiple excel spreadsheets

[mojo1979]

Hi,

I'm trying to import data from a number of excel spreadsheets (which have the same formating, but saved with different names, and at different locations) into an access table (access 2000 file format in access 2003). Can i create a macro to do this? if so what would it need to consist of?

I need to automate this as much as possible. I will need to run it on excel spreadsheets already completed and on any spreadsheets created in the future.

Any help would be greatly appreciated!

Thanks

 

[alastair69]

I am having the same problems with access, but slightly different as in a word like a form to load and you can place the file location into it and then type in the sheet name and access will import the excel speadsheet.

Could you let me know if you sort this one.

Alastair