Prev: Coversion problem
Next: Outlook PST Files
From: Scott M. on 11 Oct 2006 21:56
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(a)paco.net> wrote in message
news:be1391bf1c5218c8bb6e9594ebe3(a)news.microsoft.com...
> 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(a)paco.net> wrote in message
>> news:be1391bf1c1ee8c8ba8d6a850af6(a)news.microsoft.com...
>>
>>> 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(a)pfmail.com> wrote in message
>>>> news:%23pruw%23K7GHA.4708(a)TK2MSFTNGP05.phx.gbl...
>>>>> 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."
>
>


From: "Jon Paal" Jon[ nospam ]Paal @ everywhere dot on 11 Oct 2006 23:48
set the extended properties to 'text' for csv file and remember to create the ini file for field definition


"fniles" <fniles(a)pfmail.com> wrote in message news:%23pruw%23K7GHA.4708(a)TK2MSFTNGP05.phx.gbl...
>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."
>
>


First  |  Prev  | 
Pages: 1 2 3
Prev: Coversion problem
Next: Outlook PST Files