Search:

Thanks for the help I found the problem I put the .Open inside the loop.


Private Sub btnImportDB_Click(sender As Object, e As EventArgs) Handles btnImportDB.Click

If txtDatFile.Text =...

Mind telling me how to do it.
Thanks for the time.

@jmcilhinney

I change my code to this


Public strConn As String = "Data Source =DTS.db;Version=3;"



Private Sub btnImportDB_Click(sender As Object, e As EventArgs) Handles...

@jmcilhinney

this is the error i get
155239

I try this but no luck


strSQL = "INSERT INTO tblTempData (fldMacId,fldDateTime,fldRem1,fldRem2,fldRem3,fldRem4)" &
...

Im trying to import .dat files to SQLite Table via vb.net

Sample Data:
155235

My SQLite Table
155237

Table Structure

@IkkeEnGij

Thank you very much..I keep you code for future reference..

@ChrisE

Thank you very much I give you an update later..

@ChrisE

The data comes from the biometric machine with the following format:
2 2017-7-20 7:05:00 1 0
2 2017-7-20 11:25:00 1 1
2 2017-7-20 12:30:00 1 0
2 2017-7-20 17:45:00 1 1
........

I can manage to get the expected result of TimeIn1,TimeOut1,TimeIn2,TimeOut2 individually in the following sql



//TimeIn1
SELECT tblTempData.fldMachineId, Year(tblTempData.fldLogDate) AS...

@ChrisE
Thank you very much for your time. Im not in the Datagrid view for now. I just want to process the data via SQL query. My old program didnt work well now in windows 10. So i decided to...

@jmcilhinney
Ohh, Thank you very much. Sorry for the wrong post. I've been happy to be moved my post in Database Development. I really need help on this.

Im trying to process the data from tblTempData to tblPData using the ff sql


INSERT INTO tblPData ( fldMacID, fldYear, fldMonth, fldDay,fldTimeIn1,fldTimeOut1,fldTimeIn2,fldTimeOut2 )
SELECT
...

si_the_geek

Thank you very much for the detailed explanation.

si_the_geek

Compare to my old code yours is much simpler. Would you mind explaining the following lines:



T2.fldTimeLog - Int(T2.fldTimeLog) as TimeIn1
T3.fldTimeLog - Int(T3.fldTimeLog)...

si_the_geek

Thank you very much for the reply..

Please see the original extracted data from biometric machine.

155049

TimeIn = 1
TimeOut = 2

Im having problem converting columns to rows and placing the data in proper place.
Please see image below.

155047

Im rebuilding my old vb6 program to vb.net.
I really appreciate any help....

@jmcilhinney

Thank you very much.. I found the answer based on your codebank examples.

Hi @jmcilhinney

I already check your code banks but it seems that is not the answer i need. I want to load the dat file to ms access table and show it using DataGridView. If you say that i dont...

Thank you very much.. I give it a try.. I keep you posted later thanks for your time.

I successfully manage to load the .dat file from the DataGridView using the below code.



Private Sub Button4_Click(sender As Object, e As EventArgs) Handles btnToTable.Click
Dim fname...

Thank you very much. I give you an update later.

This is my code:


Private Sub OpenFileDialog1_FileOk(sender As Object, e As System.ComponentModel.CancelEventArgs) Handles OpenFileDialog1.FileOk
TextBox1.Text = OpenFileDialog1.FileName...