I'm working on a console application to load the contents of a text file into an access table.(access 2002) The text file varies in records, but could be for example:50000 records.
the code to do so is:
Dim Conn As New OleDb.OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dest_db1)
Conn.Open()
Dim Comm As New OleDb.OleDbCommand("INSERT INTO assist([tool],[lot_cntr]) SELECT col1,col2 FROM [Text;Database=" & strexportpath & "\" & ";HDR=YES;FMT=DELIMITED].[ws_assist.txt]", Conn)
Comm.ExecuteNonQuery()
I have developed the application on a W2000 OS and it runs without any problems.
On a few XP systems ( home edition, but also professionell) it doesn't do the db transfer at all. On the other side on some XP labtops it is running.
The error coming up is ( translated
"for at least one parameter no value is given"
the contents of the text file is:
DV17, 2 ' 1st field = string
DV17, 3 ' 2nd field = integer
DV17, 5
DV17, 9
DV17, 12
When using the first field only, the db transfer works.
But when including e.g.: the second field it's failing.
I'm totally stuck any help is really appreciated.
Thanks in advance
the code to do so is:
Dim Conn As New OleDb.OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dest_db1)
Conn.Open()
Dim Comm As New OleDb.OleDbCommand("INSERT INTO assist([tool],[lot_cntr]) SELECT col1,col2 FROM [Text;Database=" & strexportpath & "\" & ";HDR=YES;FMT=DELIMITED].[ws_assist.txt]", Conn)
Comm.ExecuteNonQuery()
I have developed the application on a W2000 OS and it runs without any problems.
On a few XP systems ( home edition, but also professionell) it doesn't do the db transfer at all. On the other side on some XP labtops it is running.
The error coming up is ( translated
"for at least one parameter no value is given"
the contents of the text file is:
DV17, 2 ' 1st field = string
DV17, 3 ' 2nd field = integer
DV17, 5
DV17, 9
DV17, 12
When using the first field only, the db transfer works.
But when including e.g.: the second field it's failing.
I'm totally stuck any help is really appreciated.
Thanks in advance