Access to Excel - Get External Data will not import memo field
Posted on 2004-08-12
I have an excel spreadsheet from which I use "Get External Data: to bring in data from MS Access97. I link through an ODBC connection to the MS access database and then select a query. The query I select is based on another query in access. When I try to bring the data into the spreadsheet I get an error message that states "Invalid String or Buffer length"
If I run the query as a make table quer from within access and put the data into a table, I can then go to excel and use "Get External Data" and bring the data into Excel"
Is there any way to do this directly form the query in access without having to make a table in the access database first?