Limitations

[SGTPEP]

I am planning to import a large number of excel speadsheets using macros at
certain times of the month.

Is there a limitation to how many spreadsheets any one macro can handle at
any one time?

Thanks

 

[Jeff Boyce]

Check Access HELP, searching for "specifications" to see the maximum number
of steps a macro can contain.

Or you could look into using VBA and creating a procedure that imported the
spreadsheets.

Do you actually mean "import" (make a copy in Access), or are you looking at
linking to (i.e., "looking at") the spreadsheets?

Regards

Jeff Boyce
Microsoft Office/Access MVP