Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing Delimited Text Files
Message
From
27/12/2004 12:51:05
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
20/12/2004 22:17:30
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00970872
Message ID:
00972388
Views:
12
>Season's Greetings to one and all!!!
>
>Just would like to know how (if it is possible) to import a text file delimited with a pipe or vertical bar (|) into a DataTable. If this is not possible what would be the best way to retrieve the data and display it in a grid?
>
>Thanx! and MERRY CHRISTMAS to all DotNetters!!!
>
>Martin

Martin,
Impossible is nothing. However doing that directly with .Net is hard. Using a delimiter other than comma needs a schema.ini file (and luck to find out how to write it). If you'd do it with .Net then probably changing it to a regular delimited file (dblquotes and comma) or parsing on the fly would be easier.
PS: For a comma delimited file use Jet provider.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform