vb .net import txt to mdb

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • kevin.j.berish@gmail.com

    #1

    vb .net import txt to mdb

    I have seen examples on this but my question is this: Suppose I have

    Dim cmd As New OleDbCommand("S ELECT * INTO [myImport] FROM
    [Text;Database=c :\mydata].[test.txt]", conn)

    I want to not include the path where [Text; Database=c:\myd ata]
    Meaning the test.txt file will be in the same location as the
    created .exe file where ever I want to put it.

    How would I do this?

    TIA

Working...