Velocity Reviews - Computer Hardware Reviews

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

Reply
Thread Tools

import delimited text file to msde

 
 
TJS
Guest
Posts: n/a
 
      10-28-2003
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
location:

[CUSTOMERS.TXT]
ColNameHeader=False
Format=TabDelimited
Col1=CustomerID text
Col2=CompanyName text
Col3=Contact text
===========================================



 
Reply With Quote
 
 
 
Reply

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



Advertisments