Specified table does not Exist.

[Map_Freak]

Hi,
I am fairly new to programming and I am using Visual Studio Express 2010

I am trying to export a delimited file CSV or TXT into a SDF database.
But I get every time the next error:

The specified table does not exist. [ Text;C:\Users\Me\Documents\Visual Studio\Projects\CSV-Text-SDF\Oregon.text]

Searched the internet for a solution but to no avail.

The code I am using is mentioned below.

Imports System.IO
Imports System.Data.SqlServerCe
Imports System.Data
Imports System.Data.SqlClient


Public Class Form1

    Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load

    End Sub

    Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click

        Dim Path As String = "C:\Users\H.G. van Andel\Documents\Visual Studio 2010\Projects\CSV-Text-SDF\"
       
        Dim connect As String

        connect = "Data source =" & Path & "Waypoints.sdf"
        Dim conn As New SqlCeConnection(connect)

        Dim Query As String = "Insert INTO POI (Lat,Lon,Icon,[desc],Stad,Categorie,land,Staat) Select Lat,Lon,Icon,[desc],Stad,Categorie,land,Staat From [Text;" + Path + "Oregon.txt]"
       
        Dim cmd As SqlCeCommand = New SqlCeCommand(Query, conn)
        conn.Open()
        Try
            'Catch ex As SqlCeException
            cmd.ExecuteNonQuery()
        Catch ex As SqlCeException
            MessageBox.Show(ex.Message)

            conn.Close()
          
        End Try
    End Sub
End Class

Is there somebody who can help me and telling me what I am doing wrong.

Or is there a better way to do this?
Map_Freak

[Hack]

The VB Classic section is for questions on Visual Basic 6 and earlier versions, where as the .NET section is for questions pertaining to all versions of VB.NET. Therefore, I have moved your thread over to .NET (and added [code]your code goes in here[/code] tags to make reading the posted code a bit easier.)

[Map_Freak]

Hi,

Nobody made a replay to solve this problem.
I like to close this thread and if possible to remove this thread completly from this forum.

Map_Freak.

[Hack]

Did you find a solution to this problem?

[Map_Freak]

Hello Hack,

I didn't found a solution on this error.
But a developer gave me a workable solution to load a "cvs" into a SQLCE "sdf" database.
If there is a need for, you can found the code on this url http://www.vbcentral.nl/Forums/tabid...4/Default.aspx

Map_Freak

[Map_Freak]

Sorry Guys,

This site is a Dutch spoken site.

If there is a need I will Copy the code on this forum.

On one of the last quotes is an a 001_windowsapplication.zip

Map_Freak

[Hack]

I don't think you need to copy anything....if anyone is interested they can always copy and paste the Dutch code comments into Google Translator.

Thanks for posting the link.

[tkorsano]

hi there,

i have never worked with sql server ce.
however, what one might know about standard sql server might apply to sdf databases.
look at your returned error:

The specified table does not exist. [ Text;C:\Users\Me\Documents\Visual Studio\Projects\CSV-Text-SDF\Oregon.text]

it is because you made an insert into from table that is specified as path ending in a text file name.
that table really doesn't exist, so this error message is clear.
your task is really importing a text file into a sdf table.
if it was regular tsql (which it might easily be this case) can be accomplished in two or more ways.
look at this page:

http://technet.microsoft.com/en-us/l...5(SQL.90).aspx

and now look at this tsql code snippet:

BULK INSERT AdventureWorks.Sales.SalesOrderDetail
   FROM '\\computer2\salesforce\dailyorders\neworders.txt';

well, bulk insert can do this task you need.
it is like

BULK INSERT <target_table>
   FROM <path_to_your_text_file>

i know bulk insert works because i have used it.
i also know bcp utility works because i have used it too.
i don't know if ssis (dts) can be used in a sdf db.
maybe, there is no bcp utility for sdf dbs as well.
you could also try openrowset, but i haven't used this sql statement.

good luck,

tonci korsano

[Map_Freak]

Thanks tonci korsano,

For now my app works.
The next time I use a database I will come back to this thread and will try the bulkcopy option and than with a SQL database.
Thanks again for your reply.

Map_freak