Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > import delimited text file to msde

Thread Tools

import delimited text file to msde

Posts: n/a
I need to import a delimited text file to an msde table, I found discussion
item below.
anything available for msde which is comparable to this Jet example?

The TEXT ODBC driver calls the Jet database engine and reads text files via
Jet's Text IISAM driver. You may try code similar to the following:

Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\temp;Extended Properties=""Text;HDR=NO""")

Dim da As New OleDbDataAdapter("SELECT * FROM [customers.txt]", cn)
Dim ds As New DataSet()
da.Fill(ds, "Customers")

Here's the SCHEMA.INI file in the c:\temp directory. i.e. the Data Source

Col1=CustomerID text
Col2=CompanyName text
Col3=Contact text

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
XML -> Tab-delimited text file (using lxml) Gibson Python 2 11-19-2008 05:33 PM
convert non-delimited to delimited RyanL Python 6 08-28-2007 12:06 AM
comma delimited text file. JustSomeGuy C++ 4 07-28-2006 11:27 PM
Export to Tab Delimited Text File David Lozzi ASP .Net 2 04-01-2006 02:12 AM
fill dataset from reding a delimited text file TJS ASP .Net 0 12-20-2003 08:22 AM