Re: text file data
From: Andrew (dunggaze_at_yahoo.com)
Date: 09/28/04
- Next message: ganesh: "Re: Running a shutdown from a txt file"
- Previous message: ganesh: "Re: Compering and Deleting Files"
- In reply to: Ray Costanzo [MVP]: "Re: text file data"
- Next in thread: Ray Costanzo [MVP]: "Re: text file data"
- Reply: Ray Costanzo [MVP]: "Re: text file data"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 28 Sep 2004 14:00:32 -0400
text file is delimited by tabs:
name age location
Andy 25 local
Jack 19 local
Frank 49 remote
I tried to make the column names delimited by commas and other record not
changed, it works:
name,age,location
Andy 25 local
Jack 19 local
Frank 49 remote
Any idea?
-- Andrew "Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in message news:OCUjWTXpEHA.3572@TK2MSFTNGP10.phx.gbl... > Okay, again then, what does your text file look like? > > Ray at work > > "Andrew" <dunggaze@yahoo.com> wrote in message > news:nb2dnRECg-QVGMTcRVn-hg@rogers.com... > > Typos only, my code is: "select name, age from info.txt where location = > > 'local'" when I was trying. > > Even I did tried: > > "select name, age from info.txt", it also didn't work. > > > > -- > > Andrew > > > > > > > > "Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in > > message news:OQd2WdWpEHA.3464@tk2msftngp13.phx.gbl... > >> Doh! Good eye Tom! :] > >> > >> Ray at work > >> > >> "Tom Lavedas" <tlavedas@hotmail.remove.com> wrote in message > >> news:2C1A48E3-6143-40B3-9F67-6AB4B2EE32AB@microsoft.com... > >
- Next message: ganesh: "Re: Running a shutdown from a txt file"
- Previous message: ganesh: "Re: Compering and Deleting Files"
- In reply to: Ray Costanzo [MVP]: "Re: text file data"
- Next in thread: Ray Costanzo [MVP]: "Re: text file data"
- Reply: Ray Costanzo [MVP]: "Re: text file data"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|