Re: Creating a CSV from query results

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Michelle" <nospam_mbytwo-news@xxxxxxxxxxxx> wrote in message
news:dvq9rk$gja$1@xxxxxxxxxxxxxxxxxxxxxxx
Thanks Steven

I will have a look at your post in further detail over the next couple of
days (understand that it's untested).

I just need a start to learn how to read from a query set that I produce
in either SQL Express or Access.

Michelle


One additional note. If the data you are retrieving has embedded commas in
them (i.e. City, State zip) the example will not produce a correct CSV file.
At a minimum, strings should be enclosed in quotes, just to be safe.

--
Al Reid


.

Relevant Pages

  • Re: Proper syntax for Is Null is Select Case
    ... > select * from tblCustomers where City is Null ... > allow zero length strings, ... > For me, as a developer, I want ONE thing that means a empty city field. ...
    (microsoft.public.access.forms)
  • Re: convert string into a variable object
    ... I would certainly use String for city names. ... A Hash seems like a good fit here. ... if he's not actually wanting to remove anything, I don't think Strings ... Is there something I'm missing? ...
    (comp.lang.ruby)
  • Re: Climate Change is Real
    ... City, Avalon, Stone Harbor, the Wildwoods, Cape May, and the ... they'd all be strings of empty buildings along a ... Might as well say the cities are suburbs ... as they'd be a string of empty buildings without ...
    (rec.arts.comics.strips)
  • Re: Scripting Question
    ... Except, as pointed out, when there are embedded commas in a field. ... running to you local Python documentation to read up on the csv module. ... But the original idea was that you could have commas in strings as ... quotes in quotes strings, etc, etc... ...
    (Ubuntu)
  • Re: VLOOKUP
    ... "Lisa12" wrote in message ... same cell. ... Example City, State. ... How do I connect the two strings? ...
    (microsoft.public.excel.worksheet.functions)