One of the easiest ways I know is to create a DB in Access and then you can use the LINK feature of access to link the Excel file as a Datasource. Then you can query the Access db as you would any other Access DB.
I wouldn't use this in a Production evironment, it wouldn't be able to take alot of hits. - tleish
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.