Re: FN-FORUM: Harddrives and SQL questions

date posted 4th April 2007 09:50

Why not do a database query from Excel and import it? Or change the
delimiter. Usually, if you export as CSV and there are commas in the
data, the app puts in " or ' as delimiters or uses ; instead of , (and
you can specify these in the Excel import wizard - don't open directly
in Excel, do Data, get/import external data, then break the link by
deleting the named range.

--
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Kathy
http://www.vendetta.co.uk
+44(0)7005 982 261
DNRC Minister for Useful but Irritating Information and Trivia
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
----- Original Message -----
From: "Adam Reynolds" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Tuesday, April 03, 2007 8:38 PM
Subject: Re: FN-FORUM: Harddrives and SQL questions


>
> I would suggest that Excel is handling the file incorrectly. Another
> option is to change the deliminator on the export.
>
>
>
> Adam Tuffin wrote:
> > HI,
> >
> >
> >
> > I have two separate questions but I though I would put them in the
same
> > email to save writing two:
> >
> > 1. Does anyone know some good software for finding out how old a
hard disk
> > is? I am sure that I saw one a couple of years back that was part of
a suite
> > of programs for checking you system hardware status but I can't
remember
> > that name.
> >
> > 2. Every now and again I have to export data from a SQL database
for a
> > client. The problem is when it exports it saves it as a CSV file.
When I
> > import the data into excel, it splits the fields incorrectly as the
client
> > uses commas in there comments.
> > Does anyone know how to export the data directly into excel so I can
avoid
> > this.
> >
> > Kind Regards
> > Adam Tuffin
> >
> >
> >
> >
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>