Export to Excel query

Hi have succesfully exported data from db to excel and dynamically generated
filename, problem is I need a space between the invoice ID and Customer
name, at present it generates the data but joined together eg 311Mackenzie
Centre should read 311 Mackenzie Centre

<%
sData = (request.querystring("InvoiceID")) +
(Customers.Fields.Item("CompanyName").Value)
Response.AddHeader "Content-Disposition","attachment; filename=" + sData
Response.ContentType = "application/vnd.ms-excel"
%>

Anyone help?

Regards
Simon Gare
The Gare Group Limited

website: www.thegaregroup.co.uk
website: www.privatehiresolutions.co.uk

Re: Export to Excel query

sData = (request.querystring("InvoiceID")) + " " +
(Customers.Fields.Item("CompanyName").Value)

--
--Mark Schupp


"Simon Gare" wrote in message
news:OJqJ4rPMHHA.2140@TK2MSFTNGP03.phx.gbl...
> Hi have succesfully exported data from db to excel and dynamically
> generated
> filename, problem is I need a space between the invoice ID and Customer
> name, at present it generates the data but joined together eg
> 311Mackenzie
> Centre should read 311 Mackenzie Centre
>
> <%
> sData = (request.querystring("InvoiceID")) +
> (Customers.Fields.Item("CompanyName").Value)
> Response.AddHeader "Content-Disposition","attachment; filename=" + sData
> Response.ContentType = "application/vnd.ms-excel"
> %>
>
> Anyone help?
>
> Regards
> Simon Gare
> The Gare Group Limited
>
> website: www.thegaregroup.co.uk
> website: www.privatehiresolutions.co.uk
>
>

Re: Export to Excel query

Thanks Mark worked perfectly

Simon

"Mark Schupp" wrote in message
news:uy%23zr7PMHHA.4196@TK2MSFTNGP03.phx.gbl...
>
> sData = (request.querystring("InvoiceID")) + " " +
> (Customers.Fields.Item("CompanyName").Value)
>
> --
> --Mark Schupp
>
>
> "Simon Gare" wrote in message
> news:OJqJ4rPMHHA.2140@TK2MSFTNGP03.phx.gbl...
> > Hi have succesfully exported data from db to excel and dynamically
> > generated
> > filename, problem is I need a space between the invoice ID and Customer
> > name, at present it generates the data but joined together eg
> > 311Mackenzie
> > Centre should read 311 Mackenzie Centre
> >
> > <%
> > sData = (request.querystring("InvoiceID")) +
> > (Customers.Fields.Item("CompanyName").Value)
> > Response.AddHeader "Content-Disposition","attachment; filename=" +
sData
> > Response.ContentType = "application/vnd.ms-excel"
> > %>
> >
> > Anyone help?
> >
> > Regards
> > Simon Gare
> > The Gare Group Limited
> >
> > website: www.thegaregroup.co.uk
> > website: www.privatehiresolutions.co.uk
> >
> >
>
>