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