An Airport Express would suffice, I think.
EDIT : just tried with an Airport Express, a MBP, and an iPad mini.
The Airport Express "create a wireless network", is set up as a router, and not connected to a wired network.
Therefore, I have no access to Internet, but I can transfer files from the Mac to the iPad, or from the iPad to the Mac via Instashare.
Works fine.