Help exporting URL format to Excel from Access Query

[Dave]

I have an Access query that is generating URLs for reports. I need to export
it in Excel. When I do, it places an apostrophe ' in front of the text in
excel.

Is there a way to export the query data without the apostrophe or a way to
strip the apostrophe in the excel column?

Thanks

 

[pietlinden]

I have an Access query that is generating URLs for reports.  I need to export
it in Excel.  When I do, it places an apostrophe ' in front of the textin
excel.

Is there a way to export the query data without the apostrophe or a way to
strip the apostrophe in the excel column?

Thanks

what happens if you open an ADO recordset based on the query (stored
procedure) and then use CopyFromRecordset and send it to Excel that
way? there's code to do that at www.mvps.org in the modules section.
note that you cannot have spaces in your query name, because ADO will
fail to find the stored procedure. (I've been down that road once or
twice!). Then you should be fine.