Re: How to open a .CSV file ?
- From: "Scott M." <s-mar@xxxxxxxxxxxxx>
- Date: Thu, 12 Oct 2006 19:25:19 -0400
I'm really having trouble understanding why you feel the need to insult
people who have not insulted you?
I'm also having difficulty understanding why you haven't bothered to read
any of what I wrote. I know that you haven't, because if you had, you
certainly wouldn't say that by my reasoning every file should be accessed as
a string. How can I know that? Well, because I never said that. In fact,
I said (on more than one occassion) exactly the opposite (and agreed with
you).
Clearly, you just feel you need to take out some frustration you have on
others. Because any objective person reading what I wrote would not come to
the conclusions you've come to. It sort of sounds like it doesn't matter
what anyone says, you've got the "my way or the highway" mentality.
Good luck with that.
"GhostInAK" <paco@xxxxxxxx> wrote in message
news:be1391bf1c80b8c8bc24c9b71f3c@xxxxxxxxxxxxxxxxxxxxx
Hello Scott M.,
Wow.. I've been such a fool.. it's taken your inspired words to make me
see the light.
I suppose by your reasoning every file is just a big long string and we
should all be using the string manipulation functions to work with them.
Yer bein an ass. Just admit when yer wrong.
-Boo
(really trying to avoid a flame war) Scott M. writes:
With all due respect, your suggested way is great (and may even be the
"better" way in this scenario), but by no means is it the "right" way.
The OP said very little about the size of the CSV or how complex the
data inside it is. Without knowing the answers to those questions, it
would be foolish to suggest what the "right" way to proceed would be.
May I suggest that if you believe that using String methods to parse a
string is "amature", you may be a bit closed minded to other
programming possibilites. There is never just one correct way to
solve a programmatic problem.
If you would take your blinders off, you might realize that different
scenarios require different approaches.
Good luck.
"GhostInAK" <paco@xxxxxxxx> wrote in message
news:c71747b44b1e38c8bb92a18c9900@xxxxxxxxxxxxxxxxxxxxx
Hello Scott M.,
Well, you can do it the amature way or you can do it the right way.
Matters not to me - I won't ever be using any of the crap you write.
The OP had it right, even if the details were buggered. The correct
way
to work with CSV files in .NET is vial the OleDb namespace. Any
other
home-grown hand-rolled crap is wasted effort.
-Boo
And, by the way. we are talking about a file that contains nothing
but a string within it, so using string methods on this string is
hardly "stupid".
"GhostInAK" <paco@xxxxxxxx> wrote in message
news:be1391bf1c5218c8bb6e9594ebe3@xxxxxxxxxxxxxxxxxxxxx
Hello Scott M.,
Well, yes, you could write your own CSV parser as MDO did.. but
that would serve no practical purpose other than to teach you how
to write a string parser.
I assume when you said "parse at the comma" you meant string.split.
While you could use this function, it would be stupid to use it on
a CSV file. Quoted values are going to kill you. It's not worth
it.
-Boo
You can use this technique to parse the file at any character, it
doesn't have to be the comma.
"GhostInAK" <paco@xxxxxxxx> wrote in message
news:be1391bf1c1ee8c8ba8d6a850af6@xxxxxxxxxxxxxxxxxxxxx
Hello Scott M.,
Because not all CSV files are supposed to be parsed at the comma:
Value One, "Value, Two", Value Three
OP, your connection string is wrong. Try:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\;Extended
Properties=Text;
-Boo
Why not just use a StreamReader class and parse the values at
the commas?
"fniles" <fniles@xxxxxxxxxx> wrote in message
news:%23pruw%23K7GHA.4708@xxxxxxxxxxxxxxxxxxxxxxx
I have a .CSV file (comma delimited) that I want to open using
OLEDB,
but I
get the error "External table is not in the expected format."
If I save the .CSV file to an .XLS file, I can open the
connection
with no
problem.
What is the correct way to open a .CSV file ?
If I can not open the CSV file, how can I programmatically save
the
CSV
file to an XLS file ?
Thanks a lot.
dim myCon OleDb.OleDbConnection
myCon = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
Data
Source=c:\file.csv; Extended Properties=""Excel 8.0; HDR=NO;
IMEX=1""")
--> error "External table is not in the expected format."
.
- Follow-Ups:
- Re: How to open a .CSV file ?
- From: GhostInAK
- References:
- Re: How to open a .CSV file ?
- From: Scott M.
- Re: How to open a .CSV file ?
- From: GhostInAK
- Prev by Date: Fill DataTable Progress
- Next by Date: Re: Converting Hex Fraction to Dec
- Previous by thread: Re: How to open a .CSV file ?
- Next by thread: Re: How to open a .CSV file ?
- Index(es):