Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Access Query Data to Excel
Hi All. I have an Excel add-in function that gets data from access. It
works fine until the access query has a custom function - the query craps out because it cannot find the fuction; the function is setup in access with a reference to my "library.mda" file. The query runs fine from access, but not when I try to openrecordset from excel. Public Function GetRsFromAccess(sheetname As String, dbname As String, dbpath As String, rsname As String, pasteintocell As String) Dim db As DAO.database Dim rs As DAO.Recordset Set db = OpenDatabase(dbpath & dbname) Set rs = db.OpenRecordset(rsname) I get the Error Message: Error Number: 3085 Error Description: Undefined function 'Convert711ToStripped171' in expression." Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Query from Access | Excel Discussion (Misc queries) | |||
excel chart with data source from an access query | Charts and Charting in Excel | |||
VLookup to merge Access Query data into Excel Report | Excel Discussion (Misc queries) | |||
Create Excel PivotTable that uses Access query as external data so | Excel Programming | |||
Excel - MS Query - changing location of Access data source | Excel Programming |