[dba-Tech] Importing CSV files into Excel

Don't worry about it, folks. I realized that it was not only simpler to
import into Access, and also that that gave me a lot more control over
column types etc. So, problem solved, and way more elegantly.

Arthur


On Wed, Oct 9, 2013 at 10:36 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote:

> Oops, Reading too fast.
>
> What happens if you just import the CSV file - doesn't the field names show
> up in the first row?
>
> R
>
>
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
> Sent: Wednesday, October 09, 2013 7:35 AM
> To: Discussion of Hardware and Software issues
> Subject: Re: [dba-Tech] Importing CSV files into Excel
>
> In Access not Excel.
>
>
> On Wed, Oct 9, 2013 at 9:25 AM, Rocky Smolin <rockysmolin at bchacc.com>
> wrote:
>
> > Doesn't it come up in the wizard?  In 2003, which I still use, it's a
> > check box in the second or third screen.
> >
> > R
> >
> >
> > -----Original Message-----
> > From: dba-tech-bounces at databaseadvisors.com
> > [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Arthur
> > Fuller
> > Sent: Wednesday, October 09, 2013 6:40 AM
> > To: Discussion of Hardware and Software issues
> > Subject: [dba-Tech] Importing CSV files into Excel
> >
> > I'm trying to import some CSV files into Excel 2007, but I can't
> > remember how to tell Excel that the field names are on the first row
> > of the text file. Can someone remind me where that is?
> >
> > TIA,
> >
> > --
> > Arthur
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
>
>
>
> --
> Gary Kjos
> garykjos at gmail.com
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>



-- 
Arthur