Excel using Access as a Back End 1

[kermitforney]

I need to research using Access or SQL (2005) as a back end for an excel front end. So basically Excel is the front end and Access/SQL Server is the back end.
Can anyone point me to a tutorial or somwhere on the net with some information.

 

[SkipVought]

I do this quite often, especially when I have data from multiple data sources like Oracle & DB2.

You can query Access directly from Excel either using MS Query via Data/Get External Data or using ADO or DAO objects.

MS Query inserts a QueryTable on a worksheet and returns a resuleset to the sheet.

ADO & DAO return a resultset object that you can navigate using various methods or return the entire resultset to a worsheet via the CopyFromRecordset method.

Help for both can be obtained from VBA help or

http://www.microsoft.com.

There are also Tek-Tippers on this forum or in VBA Visual Basic for Applications (Microsoft) forum707.

Start small and learn. Post back specific question and get specific help.

Skip,

_[red][/red]